I have a table of my users with the following columns:
A - Id - the specific Id of a user
B - E-mail - the email of a user
C - Count - set to one for each email
D - Registration Date - the date on which the user registered
E - Type - the type of a user (i.ex., administrator, student, etc)
I am trying to build a line chart which shows the running total of my users day by day, something like this:
If I use: CUMULATIVE(@C:C;) it doesn't give me the output shown.
If I use: CUMULATIVE(COUNTDISTINCT(@C:C;)) it doesn't show me what I want.
If I use: SUM(@C:C;) it also doesn´t show me what I want
What additional formula can I come up with to show this chart?