Top 10 items view
we wanted to review top 10 item out of 1M items
i can apply for filter accordingly
example... how we should bring on ranking column while using beast mode
Comments
-
You can utilize the RANK window function in a beast mode. Something like:
RANK() over (PARTITION BY `List` ORDER BY SUM(`All Total`))
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
there is no column for 'All Total' column
we should consider Grand Total (Column) how we should bring top 3 items only
0 -
example here you go...
0 -
0
-
Region / Q1 / Q2 / Q3 / Q4 / Amount Total (column)
Applied beast mode as below function but doesn't work for me.. not sure how to apply ranking 'Amount Total' side. (this column doesn't appear in datatable)
RANK() OVER (PARTITION BY `Region` ORDER BY SUM(`Amount`) desc) <=10 then 'include' else 'exclude'
0 -
the result give individual Gross grand total(column) level for each Qtr and add up ranking as Net grand total.. Not sure how we can decide the ranking as grand total level top 10 items.
result should be 69,692 - rank 1
25,980 - rank 2
20,980 - rank 3
20,314 - rank 4
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