Making an accumulated sum graph with QuickSight

Question

How can I make an accumulated sum graph with AWS QuickSight? For example, I have a dataset that contains the sales for each day. I want to make a line graph for each month that has the accumulated sells day by day.

So if the dataset is:

• Day1 = 10 sales
• Day2 = 5 sales
• Day3 = 11 sales

The graph should have a line with Day 1 = 10, Day 2 = 15, Day 3 = 26, etc.

There is a function function called runningSum() in the Quicksight documentation, but how can this be used with a QuickSight Visual (graph)?

Answer 1

I was able to find an answer to this. I did it the following way:

runningSum(sum({count}), [truncDate("MM",{creationdate}) ASC], [{region}])

and I found an interesting catch.... whenever I tried adding at the moment that I'm configuring the data source, it'd fail.

So I went through and added the calculated field on the area where I can edit the visuals - and there it worked.

Here's an example of the accumulative view:

Hope it works for you.

Answer 2

have you tried using runningSum.