This content has been marked as final. Show 3 replies
Our billing system is based on a 4 week period, always beginning on the first of the month. So there are 4 periods:
1st through the 7th
8th through the 14th
15th through the 21st
22nd through the end of the month
I'm having trouble grouping my days as such. My data is literally a date and a count beside it, e.g.,
The desired affect of this grouping would be to would show week 1 with a Count of 566 and week 2 with a Count of 111 (based on the single data point above) and so on.
Could someone steer me in the right direction?