This dashboard was created for our maps visualization contest and it contains a lot of tips and tricks that really can help you in your daily work creating dashboards with TARGIT.
First Tip based on this dashboard is around color scales and maps.
Author of dashboard: Michael Overgaard from TARGIT partner KMD.
Notice the colors on the big map which is based on a color scale like this:
f you look at the numbers behind the map (just the first rows in the table) you will be able to se a problem coming up:
Since Los Angeles is such an outlier, we can expect Los Angeles to become dark red and the rest of the datapoints to become impossible to distinguish – because the outlier will “ruin” the scale.
To get around that our KMD consultant did a calculation compressing the range of values in a clever way.
I guess that calculation could be done in many ways, but in this particular case it looks like this:
Sum(d-1, 0, m1)^0.15
(The ^ symbol means power)
Let’s skip the math lesson and just accept that when you have a decimal number as the exponent, you end up with a sort of root of the number – and the numbers will basically be much more compressed.
Like I said, there are lots of ways of achieving this, but this one works very fine – the result looks like this:
Now you have a scale that is much better for showing the nuances of each datapoint.