Running aggregation

Hi. I am trying to create a visual that shows the number of users on our platform as a running aggregation. That is for example if there are 5 users on day 1, it shows 5, if 5 news users are registreret on day 2 it shows 10 users.

I have a table in which each unique id of type=“user” corresponds to a registreret users and there is a created_at timestamp attached to each.
Right now i have only been able to get a graph where it shows each data point as how many was created that day but not the aggregation over time. That means it will show 5 on day 1 and 5 on day 2.

@kkpmany ,

Maybe runningSum - Amazon QuickSight will help ?

Kind regards,
Koushik

3 Likes