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.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有