Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Making an accumulated sum graph with QuickSight

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)?

like image 618
tanaka Avatar asked Nov 30 '17 19:11

tanaka


1 Answers

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:

accumulative view on quicksight

Hope it works for you.

like image 100
luis.mazoni Avatar answered Sep 22 '22 06:09

luis.mazoni