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!
Dani aka "Mr.Dojo"
Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
**You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有