0 Replies Latest reply: May 21, 2018 3:34 PM by Elizabeth Viso RSS

    Variance from month to month

    Elizabeth Viso

      Hello,

       

      I'm trying to use a waterfall chart to show the variance from month to month but I'm just not getting it to work correctly. To calculate each month percent I use this expression:

       

      For Feb:

      (Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {'Feb'}>} [UMHC SYSTEM])/16  )

      /

      (  Count({<[EC-LS-EM]= {'EC'}>} EP#) / (16 * count({<Date={'<=$(=today())'}>}distinct Month))  )

       

      Which would be 42%

       

      then for March, it is:

      (Count({<[UMHC SYSTEM]={'100%'},[EC-LS-EM]= {'EC'}, Month = {'Mar'}>} [UMHC SYSTEM])/16)

      /

      (Count({<[EC-LS-EM]= {'EC'}>} EP#) / (16 * count({<Date={'<=$(=today())'}>}distinct Month)))


      Which would be 50%

       

      So what I'm trying to show the variance from month to month, depending what months are selected. How can I go about doing that?

       

      Thanks!