Conditional labels to show outliers

Niels Thomsen

May 06, 2021 07:09

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.

This tip - based on this dashboard - is around conditional labels to show outliers.

Author of dashboard: Michael Overgaard from TARGIT partner KMD.

Notice the labels on the map in the lower right corner (in the red square). There are only labels on the locations with more than 300.000 confirmed cases.

I guess labels in general on every data point would be impossible on a map with this number of data points – but the idea of singling out the high values (the outliers) is great!

So how has it been done?

If you open the properties of the map and look at the labels tab, you find that there is an if-then-else in the labels drop-down:

Let’s click on the gear wheel in the right hand side of the red square and look under the hood:

So Labels, Mouse-over and Titles uses the same advanced editor where you – among many other things can add an IfThenElse condition (first red square above).

There a more detailed description of using the advanced editor here in this article.

Anyway – here we dig deeper by clicking the conditional text (second red square above).

That will expand the Ifthenelse like this: