Replace "No Data" with a 0 on Map Cards

Moneyshot_
Moneyshot_ Member
in Charting

How do I change a map to show a 0 instead of "No Data"? The only option I've been able to find is "Hide No Data Items", which is unusable. I couldn't find anything in the card settings, and I'm hoping it doesn't involve an ETL solution.

Thanks!

map.png
map no data.png


Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Due to the limitations of the map chart type you can't default missing values to 0. You'll need to utilize an ETL to join to the states dataset and get a list of all the states and then fill in a 0 value.

    I'd recommend posting this idea in the Idea Exchange for the product team to review and have other users vote on.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Due to the limitations of the map chart type you can't default missing values to 0. You'll need to utilize an ETL to join to the states dataset and get a list of all the states and then fill in a 0 value.

    I'd recommend posting this idea in the Idea Exchange for the product team to review and have other users vote on.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Moneyshot_
    Moneyshot_ Member

    Thanks Grant

Categories