Question - Dynamic report based on sales ranking
We have 12 main markets that we sell - I'm looking for a way that I can display the top 3 clients fo reach market + Others dynamically.
For example, if client 1 is a top 3 client for Japan, their sales will show in Japan as "Client 1" but if they are not top 3 in China the client will be bucketed into "Others"
Any ideas on how this might be achievable?
Best Answer
-
Interesting usecase! Our cards don't natively support ranking in that way, but you can use the Magic ETL tool to add a ranking column based on that country partition you mention. Here is a link to our Knowledge Base article that walks you through the process of using Magic to create this column. You will specifically want to pay attention to the "Ranking Functions" section of the article.
Domo Product Manager for Data Transformation (MagicETL)
0
Answers
-
Interesting usecase! Our cards don't natively support ranking in that way, but you can use the Magic ETL tool to add a ranking column based on that country partition you mention. Here is a link to our Knowledge Base article that walks you through the process of using Magic to create this column. You will specifically want to pay attention to the "Ranking Functions" section of the article.
Domo Product Manager for Data Transformation (MagicETL)
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive