How to create a pareto chart with cummulative percent total contribution?

Question & Answer
1

I created these percent_total and cummulative_pct_total in excel which I can use to create pareto chart. I want to create something similar in Quicksight. I can create percent_total in quicksight but how to do cummulative _pct_total which I can use in the chart.

Chart created in excel

image
image801×433 7.12 KB

image
image360×543 21.6 KB

1 Like
2

Can you do a running sum with the percent of total?

runningSum(percentOfTotal(sum({value})),[{Category} ASC])

Then plot this as your line on a combo line and bar chart

1 Like
4

Thanks Max. This is not the correct solution but it helped me reach to the solution. SUM({value}) has error. I replaced SUM with COUNT because I want to count records for each category. Also, when we put Category ASC we are sorting on Category. We should be sorting on highest to lowest percent to create a pareto. Appreciate your time on this.

Solution:
runningSum(percentOfTotal(count({field})),[percentOfTotal(count(field)) DESC])

2 Likes
5

@Shokat Thank you for sharing your solution with the Community!

1 Like