Percentage of Total (by location)

Question & Answer
,
1

I am trying to create a filled map visual, that will not only display the total count, but also the percentage of the count that the state contributes to. So for example if there are 3 records in Florida, and 10 total records in the US, then the value displayed would be 30% for Florida. I’ve tried using the percentOfTotal function but to no avail.

The way the data is set up is that each row is an account and there is a ‘state’ column.

Ideally this would display in the tool tip area of the visual.

image
image839×427 62.8 KB

2

Can you do this?

countOver({id},[{state}])/countOver({id},[])
1 Like
3

Hi Max, I gave that a try but got a “Table calculation attribute reference(s) are missing in field wells” error.

4

Try this

avg(countOver({id},[{state}],PRE_AGG)/countOver({id},[],PRE_AGG))

5

Max, thank you so much. That worked! If by chance when I drilled down into the state I wanted to show the same thing but by zip code, would it be a similar measure? Or is there a way to include that in the previous solution?