Forum Discussion

george31's avatar
george31
Regular Visitor
6 years ago
Solved

Problems calculating week to date from selected date

I am trying to calculate the WTD (week to date starting on Mondays) and MTD / YTD figures on a table where person can select the date to base this on. It would seem it should be fairly easy as we wa...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    george31 see attached, there are many tables, for you, just look at customer service  and calendar table  and measures in Customer Service table

     

    Would appreciate Kudos 🙂 if my solution helped.

parry2k's avatar
parry2k
Super User
6 years ago

george31 so you want Week To Date total by each queue and week starting Monday, correct?

parry2k's avatar
parry2k
Super User
6 years ago

george31 see attached, there are many tables, for you, just look at customer service  and calendar table  and measures in Customer Service table

 

Would appreciate Kudos 🙂 if my solution helped.