Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a pareto chart from both x and y dimension

Hi Friends

I have a simple table with simple calculation. i did not use function to do running sum and get the percentages of total. just use the default accum, relative option in building a chart.

basically, we have contract, and customer using contract to open cases. i use the contract as dimension, sorted by descending of how many cases are opened on that contract.

check the Full Accumulation and Relative, got the table i needed, see the detail setting below

Capture.PNG

the table i got look like this:

Capture.PNG

you can see 19% of contract created 75% cases. like common 20-80 scenario!

now my question is how can i turn the number in the Case Count Accum and Contract Accum into a line chart like a pareto chart...

Best Regards,

1 Reply