How to get a cumulative count on a field by data

Question & Answer
,
1

Hi - Im trying to get a monthly cumulative count of emails created.

I have createdAt field (date) eg 2022-09-25 14:41:35 and email field with N number of rows created on a date.

I created a custom field = Count(email)

But I get this - not cumlative

image
image1018×572 45.4 KB

Thanks for any help!

Toni
I

–*

2

Hey @toni_monteiro ,

welcome to the QuickSight Community.
Just for clarification: you want to show a count of all the Emails sent in a Month? And right now it shows only the count for one day?

Could you show how it could look on a daily granularity?

BR
Robert

3

Robert - thanks. Im looking to have a cumulate count of the emails addresses (unique) created per day. As an example Day 1 - 3 new emails addresses created, Day 2 - 4 new emails addresses created, Day 3 - 5 new emails addresses created …Cumulative count over that period is 12.

Im using the email addresses as an alias for the number of new accounts created per day.

4

Is the data not correct then? Its seems like that there were 168 Emails created in February? you can also change the x axis granularity to day, then you can see how many Emails where created per Day:
image

5

the data is correct per day and can graph that - that is not the issue. However I cannot figure out how to get a cumulative graph of those email-created numbers. Bottom left is 0 and top right is the total number of emails created on the Y and date per day or month on the X.

Something like this as an graph example (not the data).

image

6

Ah soory, now i understand.
You should use a runningSum - Amazon QuickSight for this one.
Like: runningSum(count(email), [createdAt ASC])

BR
Robert

7

Works…thanks for the support.