Group Total - Aggregated Series
Community,
Is it possible to have a drill down that retains the prior level's aggregated top-level value?
I.e. I want to be able to drill down from an overview, into a series specific break out (And here's the kicker) while maintaining an additional series that displays the group total from the prior drill down.
For example, we have 7 locations, each with a given value, which can be aggregated to a group total.
Is it possible to somehow retain the "Group Total" series within the same chart?
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
Answers
-
Yes, you can. One way is to create an ETL that does the aggregate (total) and joins it back to the details.
location
value
location1
100
location2
200
location3
300
result after joining
location
value
group total
location1
100
600
location2
200
600
location3
300
600
- Create a bar chart (or another card) using the value as the metric.
- Add the "Group Total" as a secondary series, by adding it as an additional value in the "Series" field.
- Adjust the series visualization (make the group total a line while keeping individual values as bars).
If you can't do the transform, another method would be to leverage "over".
SUM(Value
) OVER ()** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive