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
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.