0

I'm trying to graph total users over a given date range. I'm able to create a query for how many new users per day, but I'm struggling to create a query that aggregates the new user count for each successive day.

Example:

Date range: 1st to 3rd of month
1st: 1 user
2nd: 4 users # 3 new + the 1 existing
3rd: 9 users # 5 new + the 4 existing
Kieran E
  • 3,616
  • 2
  • 18
  • 41
  • With gem https://github.com/ankane/groupdate check this out: https://stackoverflow.com/a/51143287/5239030 – iGian Jul 05 '18 at 17:57
  • @iGian thanks for the link! I'm already using groupdate, but I had imagined there'd be a query that would accomplish the same thing. If this isn't the case, I'll certainly be using the method you posted! – Kieran E Jul 05 '18 at 17:59

0 Answers0