How do I include category aggregation in charts?

If I have e.g. estimated revenue across two categories:

And I create a chart, it will only show a graph for each category (I can only embed one picture as a new user, so can’t show).

How do I add the aggregation function (in this case sum of revenue from both categories) to this chart?

I would create a new variable and add it to the visual like so:

Note that in the new variable, I’ve aggregated over your category by clicking the category-icon in the expression :slight_smile:

and then add it to the visual from settings:

That’s it, thank you! Wish it’d just be a toggle, suspect this is common.

1 Like