Replace "No Data" with a 0 on Map Cards

Options
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 ✓
    Options

    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 ✓
    Options

    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
    Options

    Thanks Grant

Categories