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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive