Heat Map is empty

• 

  Ole Dyring

  March 30, 2021 10:59

  Hi Frank,

  The Heat map option will only work with a Points mapping type - not an Area mapping type.

  So you need to change the mapping type to 'None' or to 'Longitude/Latitude'. The latter option of course makes most sense if your data actually contains longitude and latitude information.

  Should you need to manually add your points to the map, this can be done by dragging and dropping the dots from the dimension member list, as in my example below.

  

  BR / Ole

  2
• 

  Frank Raijmaekers

  March 30, 2021 12:28

  Thanks Ole! So for the Longitude/Latitude I have to join the customer country with an excel list with the Longitude/Latitude per country in our datawarehouse. Does Targit have such list?

  I am also curious how I can make a map with a Area mapping type with the high revenue countries red, average revenue colored orange and low revenue green. Now I see only the option to color the country (e.g. USA blue, China red etc.)

  Thanks!

   

  0
• 

  Ole Dyring

  March 30, 2021 13:08 (Edited March 30, 2021 13:09)

  Hi Frank,

  You don't necessarily have to have Longitude/Latitude per country. If you do a manual mapping - once, and only once - then TARGIT will remember it for every future use of that dimension together with that map. After all, for World wide countries, there are only 200-ish dots to be mapped.

  Of course, you can use Longitude/Latitude if you want to put in the effort in your data warehouse. This list seems to place the dots pretty much centered on the country:

  https://developers.google.com/public-data/docs/canonical/countries_csv 

  With regard to your second question, I think you can get inspired by this article (which I just created):

  https://community.targit.com/hc/en-us/articles/360018786837-Custom-color-scales-ideal-for-heat-map-types 

  BR / Ole

  2
• 

  Frank Raijmaekers

  March 31, 2021 13:24

  Perfect Ole thanks! Appreciate the prompt response and the video!

  At this moment we have 2017 version running but we will upgrade the coming months. I have to look for a sort of dynamic scale, because we have a group dashboard but also per office and per office the volumes are lower.

  0
• 

  Ole Dyring

  April 06, 2021 09:43

  You can obtain a dynamic scale by adding a calculation to your map. The calculation should calculate a relative number, e.g. an index number according to your current values range. This can be done in many ways, but e.g. something like

  sum(d-1, 0, m1) / max(d-1, all, m1)

  would produce a relative number - relative to the maximum value in the value range.

  The calculation can then be used to control your color scale in a dynamic way.

  BR / Ole

  0

Please sign in to leave a comment.