How do I show relative percentage of each category item

Hi there, I would like to have a visual that doesn’t show the absolute value of each category item but just the relative percentage of each item. For example I have a 4k users in America, 3k in Europe and another 3k in Asia. How do I create a visual that displays 40% under America, 30% under Europe and so on rather than displaying the absolute values?

1 Like

Hey @daniel_pressburg sounds like a great use case! You can accomplish this by creating a variable with a formula similar to variable[all]/variable[aggregate]. You can change the category aggregation in by clicking on the category icon next to the variable referenced in the formula.

You can now change the format to percent in the context menu and add this variable to your visuals.

Pie charts and stacked bar charts are the best choices for displaying them

1 Like