Give hierarchy to the values of a column when displayed on map

[larrychang1118]

Hello everyone,

I'm doing a covid risk map that overlays with a list of locations. The problem I wasn't able to solve is to show the color on a map with the given hierarchy to the values in a column. Specifically, we have 3 levels in the location hierarchy (state, county, city) and another column contains one of low, medium and high risk level of a location. When the data shows a city is medium level risk, we would like the map to show medium as well when we drill up to county and state, but it actually shows low. This might be because the map shows the color by the majority of lower hierarchy values or by alphabetical order of the risk level string. 

Is there a way to customize this?

[JoaoMarcelino · Accepted solution]

Hi @larrychang1118,

Welcome to this amazing community.

I've created a very small mockup file with a dimension Geography and a facts table that has the Risks (you could also have the registries of Risk "High, average, low, etc" on another dimension, but for the purpose of demonstration I'll let it be like this 🙂
Geography:

Risks:

The model and how tables relate:

That being said, I've placed the geo fields on "Location" and the Risk on "Legend". I've also given the Low, average, and high risk a value from 1 to 3.
When we choose a Country it shows the number of risks and their classification:

And so does when I choose a different granularity (City):

Is this what you needed? I can send you the file if you need, for inspiration.

Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂

[larrychang1118]

This is awesome. I didn't think of using another type of map. Thanks!