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:
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)?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With