Top 10 Display
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
This discussion has been closed.
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive