Alert arrows using charmap in SAP Dashboards

[Former Member]

Here is a quick trick on how to show alerts (up/down arrows) using character maps displayed using a label component in SAP Dashboards.

Every Font has a set of characters apart from the alphanumerics. And these set of characters vary from one font to another. These characters can be seen on character map in Windows.

1)

Open Character Map in windows by typing 'charmap' in Run:

2)

Scroll down the Character Map window to find some cool set of characters offered by the font. Some fonts like Arial, Times New Roman, etc. contain the arrows ▲▼ that we need. Select the character and copy it so that it can be pasted in the excel sheet of our Dashboards.

3)

The coloring is achieved by binding the label text color to the excel cell where a simple formula determines whether the color must be RED or GREEN based on the data value.

PS: Not all the fonts' characters are supported in SAP Dashboards. For instance, I eagerly tried out the cool characters of Windings Script but ended up with disappointment.