This content has been marked as final.
Show 2 replies
-
1. Re: Pareto Chart - Count Distinct
Bryce Larsen Dec 2, 2019 5:02 PM (in response to Richard Michaels)Hi Richard,
Drag the table calculation onto the Measures pane so you can save it as a new field (I titled it Invoice Price Pareto). With this new a Measure, you can use it in a calculated field:
First 80%:
WINDOW_SUM(IF [Invoice Price Paretto]<.8 THEN COUNTD([Global DUNS]) END)
Last 20%:
WINDOW_SUM(IF [Invoice Price Pareto]>=.8 THEN COUNTD([Global DUNS]) END)
You can remove the IF statement if you want the total. So here they are all in the title:
Hope this makes sense!
Best,
Bryce
-
GlobalDUNS_PARETO.twbx 107.2 KB
-
-
2. Re: Pareto Chart - Count Distinct
Richard Michaels Dec 2, 2019 9:10 PM (in response to Bryce Larsen)Excellent, Bryce!