Dashboard Tips & Tricks – Mouse Over Suffix

Have you ever needed to add a postfix to a number in a dashboard component?

For example a user wants to add MT (Metric Tons) as a postfix to the numbers on a line graph

Lets start with a basic line graph

DB_POSTFIX_P1

Mouse Over Values have a default number format of General

There are several different format types to choose from and each one has its own unique attributes.

General

DB_Snapshoot_General

Numeric

DB_Snapshoot_Numeric

Currency

DB_Snapshoot_Currency

Percent

DB_Snapshoot_Percent

Date

DB_Snapshoot_Date

Time

DB_Snapshoot_Time

Boolean

DB_Snapshoot_Boolean

Text

DB_SNAPSHOOT_TEXT

Our goal is to add a suffix with a value of ” MT”.

The only format that includes an attribute for suffix is Currency so while it is not the obvious choice it is the only one that will let us accomplish our task.

DB_POSTFIX_P3

Now that we have selected Currency will need to modify its attributes to format the number appropriately

1) Change Decimal Places to 0

2) Check the Suffix check box

3) Add the <space> MT to the Suffix text box

Now lets review the results

DB_POSTFIX_P4

As you can see the MT has been successfully added to the line graph by overloading the Numeric Format of Currency and apply a customized format using its attributes.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.