I am having an issue trying to wrap my head around this.
I am trying to get the count of something over the days in a date range, but I don't need a per day count, I need the count of items for each day through the date range... does that make sense?
For example... the output should look something like this.
Day1 - 12
Day2 - 18
Day3 - 24
Day4 - 32
Day5 - 80
So, on Day1, there were 12 items. On Day2 there were 6 additional, so 12+6. On Day3 there were 6, so 12+6+6, Day4 there were 8, so 12+6+6+8, Day5 there were 48, so 12+6+6+8+48.
I am sure there is a way, but I can't wrap my head around it.