Map Chart (with Incorta map) showing % of total
I am trying to use a map chart at the state level. I can show a simple aggregation by state with a count of accounts. What I would like to do is show the percent of the total population for each state rather than the count. I thought using a formula could work with count() and groupBy() but the state dimension seems to override the total population count. The formula was like this:
The result is always 1 since the group dimension on the map chart is statecd.
My bad. If you have state as a dimension, then the formula above should have been:
count(acctId) / count(acctId,groupBy())
This video shows how to use similar formula:
To show data by county, you need to set map by county and use county as a dimension.