Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need assistance in creating a table like below and have no idea on how to go about it.
Month | Total Sundays | Sundays Left | Total Mondays | Mondays Left | Total Tuesdays | Tuesdays Left |
---|---|---|---|---|---|---|
Jan | 4 | 0 | 4 | 0 | 4 | 0 |
Feb | 4 | 0 | 4 | 0 | 4 | 0 |
Mar | 4 | 0 | 4 | 0 | 4 | 0 |
Apr | 4 | 0 | 4 | 0 | 4 | 0 |
May | 4 | 0 | 4 | 0 | 4 | 0 |
June | 4 | 0 | 4 | 0 | 4 | 0 |
July | 4 | 0 | 4 | 0 | 4 | 0 |
Aug | 4 | 0 | 4 | 0 | 4 | 0 |
Sep | 4 | 1 | 4 | 1 | 4 | 1 |
Oct | 4 | 4 | 4 | 4 | 4 | 4 |
Nov | 4 | 4 | 4 | 4 | 4 | 4 |
Dec | 4 | 4 | 4 | 4 | 4 | 4 |
So basically, it is a table which says how many number of days each month has and how many are left.
Can this be achieved?
You could get such table just by using Month and Weekday as dimensions from a master-calendar: How to use - Master-Calendar and Date-Values within a pivot-chart and then using as expressions something like this:
count(Date) // totals
count({< Date = {">=$(=today())"}>} Date) // left regarding to today
- Marcus
Thanks,
So what I did was to generate a master calendar in the load script. I have the first and last day of the month. But could you give a script as to how to calculate a specific day between 2 dates.
Say I want to calculate the number of Sundays between 01/01/2017 and 01//31/2017, how do I do it?
Help is appreciated. Thanks
It was meant to use Month as vertically dimension and Weekday as horizontally dimension and than using just the above mentioned count-functions.
- Marcus