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
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
Numeric
Currency
Percent
Date
Time
Boolean
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.
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
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.