We are building a portal, and we want to count number of ‘things’ over time, but I don’t seem to be able to achieve this based on a rolling month/week.
E.g. if we wanted to show our user, how many times they have logged in each month over 6 months.
All I can seem to get to work, it to show the date of each login, so if they log in 5 times in a day, that’s the x-axis, instead of accumulating 5 logins for that month. All advice super appreciated.
If it helps, I’d add one thing to @lantzgould’s response… for Group By’s starting date, you can use Current date/time +(months): -6 if you want to show the counts as a rolling window of the last 6 months.
