Bar chart- return top 10 rows by year
Hello,
I have a dataset in excel with "year", "viewers", and "market" columns. Is there a way to have the top 10 markets (based on # of viewers) return by year for 3 years. For instance, in the "year" column, we have 2017, 2018, and 2019. Each year has its own bar column. I want the top ten "Markets" based on "viewers" for each year. When I currently try to do this, it ranks the markets for all 3 years and returns the top 30 in total but I need the top 10 of each year independantly.
Thanks!
Comments
-
is this what you are aftering?
0 -
hmm.... I just realized think it is a lil buggy. Unfortunately, the max number of bars doesn't seem to apply. So if you have more than 10 markets, all the market will appear in the chart if the setup is done as shown in the screenshot. I'll play around a lil bit more to see if can cap it @ 10.
0 -
Try this to cap to 10. Create the rank and then apply the filter in the dasboard.
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/03ETL_Actions%3A_Rank_and_Window
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 703 Automate
- 182 Apps
- 458 APIs & Domo Developer
- 53 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive