How to add a red alert dot

by Zdravka Bratuhtcheva

In this blog I will show you how to add a red dot in the begging of a horizontal bar chart. I will use a bar chart I created for my previous blog. For this example I will indicate what orders it took above the average days to ship.

Lets get straight into it!

Step 1: Create a calculated field the average days it took to ship an order across all years and all orders

{ FIXED: AVG([Days it took to ship])}

Step 2: Create a calculation for an alert flag:

IF [Days it took to ship]>[Average days to ship] THEN '●' ELSE '' END

Step 3: Drag the Alert Calc to the rows shelf. It is important to place it after the Sort by calc blue pill.

Now we have a dot for each order that took more than the averae it took to ship. It would be nice to colou’r this dot red, won’t it? Let’s do it!

I right click on the dot itself and select Format from the drop down menu.

Then from the Font drop down I choose a color that I fancy. It this case this is red.

And Voila! We have a red dot to show what orders took longer to be shipped than the average.

Avatar

Zdravka Bratuhtcheva

Mon 04 Jul 2022

Thu 30 Jun 2022

Wed 29 Jun 2022