Pareto 8020
As we know, a Pareto is used to display top offenders based on their impact in the analyzed data. How can I limit a Pareto chart to only display items that are below or equal to 80% of the total?
There's no chart option for it, so I assume it's gonna take ETL or SQL to solve this, any ideas or guidance please? Also, this needs to be dynamic =S
Thanks in advance.
Comments

Hi @MartinB
You're correct in that it's not possible with the Pareto plot. Because you want it to be dynamic and ETL likely isn't going to work for you and you'd need to do it on the card itself. You might be able to do something similar with a Line + Bar chart and calculate the Pareto value via a Beast Mode for the line of the card.
You'd need to have Window Functions available in your instance to dynamically calculate the Pareto value. In addition to the window functions you'd also need the Aggregate Filters alpha to filter your chart based on the beast mode calculated Pareto value. You can talk to your CSM about these but again, Aggregate filters is in alpha and may not always work as expected.
The other option is to calculate it in an ETL and lose some of the dynamic filtering abilities.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 
Agree with Grant.
By design the Pareto will do a cumulative sum of the data displayed. So even if you filter out 20% of the value, the remainder will be the new 100%.
what you can do is the grouped bar and chart.
for the line calc, "if pct of **bleep** sum / total > .8 then .8"
if you want to do the same for order quantity you could just alter the case statement. just be advised you'll have trailing blank space in the card that might look funny.
case when
sum(sum(`Order Quantity`)) over (order by `Delivery Month`) / sum(sum(`Order Quantity`)) over () > .8 then .8
else sum(sum(coalesce(`Order Quantity`,0))) over (order by `Delivery Month`) / sum(sum(coalesce(`Order Quantity`,0))) over ()
endJae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
 11K All Categories
 5 Private Company Board
 2 APAC User Group
 12 Welcome
 43 Domo News
 9.9K Using Domo
 2K Dataflows
 2.5K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 349 Workbench
 267 Domo Best Practices
 12 Domo Certification
 474 Domo Developer
 51 Domo Everywhere
 111 Apps
 728 New to Domo
 85 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 303 仲間に相談
 664 ひらめき共有