Bar Chart with Percentage of Population

[evansabres]

I am attempting to create a bar chart to show percentage of accounts by age group.

Dimension = [Age Group]

Expression = COUNT(acctid)

When I do this, i get the correct number of accounts per age group, however, i would like to show this as a percentage.

How can I do this?

[inspari_dfg · Accepted solution]

Use this as your expression: COUNT(acctid) / COUNT(TOTAL acctid)

And then change the numberformatting to percentage