Chart help - simple question Number of 'things' over time (in months)

Need help
1

Hi all,

I’m sure this is super simple.

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.

Matt

2

try the Group By function in your search.

3

@matthew2

image
image682×519 25.4 KB

4

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.

5

Amazing, thank you! I got as far as grouping - but didn’t quite get there. The above helped me get this sorted, thank you all!!