Pareto Report - trying to limit number of categories returned
So... I'm attempting to abuse the Pareto report type a bit (fine, probably a lot).
I presently have two reports, one that includes a full category set, like the report intends, and one that is just the top 10 categories. The problem is that I'm grabbing the top 10 at present by manually filtering them, which is obviously not a great solution as we except quite a bit of change over time.
Is there any way of limiting the number of items displayed as can be done for other report types? or an easy way of producing a rank order via Beast Mode for this purpose?
These are the thumbnails of what I currently have in place:
I'm mostly trying to do this because one of our data consumers really likes that percent of total line.
For reference I am also aware of the following knowledge base article: https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window
That article, based on what I've seen in previously asked questions, seems like it may be the actual road forward. But hey, can't hurt to see what other suggestions may be available
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board