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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 440 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive