2 Replies Latest reply on Nov 2, 2016 3:25 AM by Rob Rimmer

    Calculating percentage of month passed so far (weighted weekends)

    Rob Rimmer

      Hi,

       

      I am trying to add a few measures to my dashboard relating to how much of the month has gone, how many days in a month, and using these values to estimate volumes of calls our business is likely to receive by the end of a month.

       

      So far i have the following:

       

      Days Gone in Month: DATEDIFF('day',(DATEADD('day',-(DAY(TODAY())-1),TODAY())),TODAY())

       

      Days in Month: DATEDIFF('day',DATEADD('day',-(DAY(TODAY())-1),TODAY()),DATEADD('month',1,DATEADD('day',-(DAY(TODAY())-1),TODAY())))

       

      Days Remaining in month: DATEDIFF('day',TODAY(),(DATEADD('day',-(DAY(TODAY())-1),(DATEADD('month',1,TODAY())))))

       

      % Month Gone: [Days Gone in Month]/[Days in Month]

       

      I think these expressions achieve my initial goals, but I now want to be able to weight weekends so that they account for half of a normal day, or failing this don't count at all.

       

      Do you have any ideas on how to achieve this?

       

      Thanks,

       

      Rob