Group Total - Aggregated Series

Data_Devon

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?

ArborRose

Yes, you can. One way is to create an ETL that does the aggregate (total) and joins it back to the details.

location	value
location	location1	value	100
location	location2	value	200
location	location3	value	300

result after joining

location	value	group total
location	location1	value	100	group total	600
location	location2	value	200	group total	600
location	location3	value	300	group total	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 ()