Top 10 Display
If I am working a simple card bar chart and only want to show the Top 10 (or Top X) of the data set, how can that be done? I look in Data Flow ETL and also card Beast Mode and don't see anything intuitive to accomplish this what I am guessing is a pretty standard query.
Comments
-
At the bottom of the analyzer, you can designate how many rows you want to include - if the data set is structured to allow for this and sorted correctly, you can select the top 10 rows, for example.
If aggregations are necessary or if more transformations are required, another approach could be to use a rank and window function in Magic ETL - you can perform aggregations using a combination of Group By and/or Rank and Window tiles, rank on the values you are seeking to use and then on the card, you could filter on your rank field to include only rank values of 1-10.
2 -
If the reply, was helpful please click on "Accept as Solution".
Thanks!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 7 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 661 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 819 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 781 Automate
- 193 Apps
- 483 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 43 AI and Machine Learning
- 22 AI Chat
- 3 AI Projects and Models
- 18 Jupyter Workspaces
- 409 Distribute
- 116 Domo Everywhere
- 282 Scheduled Reports
- 11 Software Integrations
- 146 Manage
- 142 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive