Trying to figure out how to get this data set up in card
I have the following data below. I would like something like the grouped bar graph where the bottom would be my "y" column the values would be my "z" column BUT I only want to display the top 3 values of "x" column. So with the current data it should only display the values from where "x" is 4,5, and 6 ..... so when this gets updated and "7" comes in it should only display 5,6, and 7.
Hopefully I explained it well lol. Any help is appreciated
Best Answer
-
You will need to use an ETL and the Rank & Window tile to do this using Dense Rank using the 'x' column in descending order.
Then when you go to create your card with the new dataset, if you called the ranking column in the ETL 'Rank', you would just create a filter where 'Rank' is less than or equal to 3, to give you the latest 3.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0
Answers
-
You will need to use an ETL and the Rank & Window tile to do this using Dense Rank using the 'x' column in descending order.
Then when you go to create your card with the new dataset, if you called the ranking column in the ETL 'Rank', you would just create a filter where 'Rank' is less than or equal to 3, to give you the latest 3.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 -
Ahhh gotcha, I was seeing if there was a way around the additional layer of ETL but I guess i will stick with this. Thank you!
0 -
I think that you can accomplish this by combining the sort field and the Limit Rows field. (note that the summary number will still include all of the data though). The trick is that you need to know how many rows of data are going to make up the 3 groups that you are looking for, in this case 9 rows.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
Ohhh snap ok I will investigate to see if they always have a set number thanks for this! no idea we had that limit rows ability
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive