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
 All Categories
 1.1K Product Ideas
 1.1K Ideas Exchange
 1.2K Connect
 966 Connectors
 254 Workbench
 Cloud Amplifier
 1 Federated
 2.4K Transform
 75 SQL DataFlows
 499 Datasets
 1.8K Magic ETL
 2.7K Visualize
 2.2K Charting
 360 Beast Mode
 19 Variables
 483 Automate
 101 Apps
 378 APIs & Domo Developer
 6 Workflows
 22 Predict
 6 Jupyter Workspaces
 16 R & Python Tiles
 316 Distribute
 64 Domo Everywhere
 252 Scheduled Reports
 59 Manage
 59 Governance & Security
 1 Product Release Questions
 5K Community Forums
 37 Getting Started
 23 Community Member Introductions
 63 Community Announcements
 4.8K Archive