How do you restrict the summary number to only sum the top x rows (already filtered in show x rows)?
I'm trying to have a summary number total the top 20 opportunites in our pipeline. I've restricted the chart to only show the top 20 by the "show only 20 rows" option and sorted by size of deal. However the summary number totals the whole pipeline and not just the 20 rows that have been filtered when viewing the card. Does anyone have any idea on how to restrict the summary number to just the top 20?
Comments
-
If you can add a column to your data flow that would flag an opportunity as a "Top 20" opportunity. You could use this to create a beast mode that would sum only those opportuntities with the "Top 20" flag.
This could be used as your summary number instead of the standard series total.
0 -
Yeah, that would work if you always wanted the top 20. However, it would be much more helpful to have the summary number dynamic if you change it from top 10 to top 20 for example.
Thanks for the idea!
0 -
@Johndogg, did @Kung-fu_Panda's reply help you out?
0 -
Domo support reached out and this is currently not possible without building a static dataflow. They are putting in a functionality request to the dev team for this feature.
Currently you must build a dataflow and aggregate the data to a set number of rows. You would then need to change the dataflow for every change in x rows (ex: top 20 to top 30).
1 -
Do you guys have any new solution to this question? I see that this was posted a couple of years back so I am wondering if there have been any updates to Domo that would solve this issue more efficiently. I am undergoing the same issue and need to show totals based on Top 10 values not all values. Many thanks!
0 -
You could fix this in an ETL transform by using the rank function to create a new column. Then you could use that column as a filter to get the top 10, top 20, or whatever version of this you would like.
Hope this helps!
1 -
Has this been resolved now? I'm trying to make table charts to only show the 20 highest revenue sales and I need it to only total the rows showing.
When I add a total row/summary number, it is totalling the entire value on the dataset and not the 20 rows which are being shown. Don't see an option to change it?1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive