Table Card - Only total displayed rows
I am trying to create a table card which shows the top 20 highest value opportunities.
I can't mark them in the dataset as 'top 20' because the values change everyday; but I need the 'Grand Total' row of the table to only show me the 20 rows displayed - not the full value of the data.
Is there anyway to do this?
Comments
-
I've done something similar with using Single Bar chart option and then limit the Maximum Bars in the General settings and then sort by whatever value you're using for "top". But that wouldn't help your 'Grand Total".
What you may have to do is do an ETL for this and do the top 20 grouping seperately and do the aggregation there and bring it over as a value called 'Grand Total' and just include it with the other 20 actual values. Then in your table card, do some color rules so that your Grant Total line shows up differently.
Not the best path to make this happen b/c you'll lack some drill down functionality but it would get you what you need I think.
Matt0
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
- 99 SQL DataFlows
- 613 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 726 Beast Mode
- 52 App Studio
- 40 Variables
- 676 Automate
- 173 Apps
- 450 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
- 9 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 107 Community Announcements
- 4.8K Archive