Making a top 5, bottom 5 filter card
I have two cards which show: 1) a bar graph of revenue per product. 2) a bar graph of fill rate per product.
There are more than 40 products. I want to add a filter in my dashboard for "Top 5" and "Bottom 5", instead of making four new cards for top 5 and bottom 5 products (2 for revenue and 2 for fill rate).
Anyone has an idea of the simplest way to do this?
Best Answer
-
Why not just use the default of the single bar? Set the max bar and you can sort the top/bottom by just click on the A->Z icon on the top
0
Answers
-
Why not just use the default of the single bar? Set the max bar and you can sort the top/bottom by just click on the A->Z icon on the top
0 -
That was because I wanted to be able to see all the datapoints, not just top 5. But also have the capability to see top 5, bottom 5.
But your idea is also workable. Just a question: from the dashboard, can the user switch between seeing only top 5 and all the data points?
0 -
If you want to see all other data points, remove the maximum bar option.
Sort by clicking on the sort icon. You can see the top and bottom in one glance.
If you have both options, you can with
1) create a rank against the data << more work as rank is only available in magic ETL or MySQL
2) create a drill path ( see below )
Same as before, create a top/bottom 5 chart and uncheck the "Hide Other' Bar. Then, create a drill path to drill down "Others". As market {11,10,2,7,5} does not belong to "Others", you can just remove the filter to see All data points.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive