You can customize how different types of data is displayed on the charts using the Format section. The basic interface for the section is shown below:
As shown above, each of the measures involved in the chart can be customized separately. For each measure, there is a text-box to provide a custom Label for the measure. Four different types of data can be displayed on the charts – Text, Number, Date and Duration (time-interval). The available options for each of these types are explained below.
Formatting Text values
The interface for formatting Text values is shown above. It provides a list of all the available values for the measure. Clicking on each of the values opens a text-box where you can provide a new value for it. Once all the desired values are customized, you can hit Apply to use the new values everywhere on the chart. Clicking the Reset button will restore all the original values and use them on the chart.
Formatting Number values
The interface for formatting Number values is shown above. There are two parts to formatting a number. First, the number is converted to different units based on Data Units and Conversion Scheme. Then, the converted value is formatted based on Custom Format and Data Type.
Converting to different Units
The Data Units text-box can be used to specify the units for measures like Functions. You can select a Conversion Scheme or disable conversions by setting it to No Conversions. If the conversions are enabled, the list of possible units are populated in the Convert Units To menu. If you want all the values to be converted to the same units, select those units from the Convert Units To menu. If you select the Automatic option, then the units are dynamically selected based on what is more readable (for example, the value “100,000,000” is more readable as “100 million” than “100,000 thousands”)
Formatting the converted number
You can format Number values by specifying a Spreadsheet-like format-code. Vizard supports a subset of all the format-codes supported by popular Spreadsheet tools for Numbers. If you do not specify any format-code, then a default formatting is applied using the Data Type.
Commonly used Number format-codes
Here are some of the commonly used format-codes for Numbers:
- #,##0 : Removes all decimal digits by rounding to the nearest integer. Displays values using commas to separate thousands, millions, etc.
- #,##0.00 : Rounds the value to two decimals. Displays values using commas to separate thousands, millions, etc.
- 0,”K” (or) 0.00,”K” : Display values in thousands, using a suffix “K”
- 0.0, “Thousand” : Display values in thousands, using a suffix ” Thousand”
- 0,,”M” (or) 0.00,,”M” : Display values in millions, using a suffix “M”
- 0.0,, “Million” : Display values in millions, using a suffix ” Million”
As mentioned above, Vizard supports a subset of all the format-codes supported by Spreadsheet tools. These are some of the known limitations:
- Special characters like ?, _, * etc., which are used to align table cells, may not work as expected
- Color codes like [Red], [Green] etc. are not supported
- Some of the codes can be treated as invalid by the parser. In these cases, a clear warning is given before-hand. e.g. #,###.0, #,###.000
Formatting Date values
The interface for formatting Date values is shown above. You can use Spreadsheet-like format-codes to customize Date values. Vizard supports almost all the format-codes supported by Spreadsheet tools for Date values. The only known limitation is that any date values before Mar 1st, 1900 will be incorrectly displayed.
Commonly used Date format-codes
Here are some of the commonly used format-codes for Dates:
- dd mmm yyyy, hh:mm AM/PM e.g. 01 Jan 2017, 05:30 PM
- ddd, yyyy mmmm dd h:mm:ss AM/PM e.g. Sun, 2017 January 01 5:30:59 PM
- d/m/yy h:mm e.g. 1/1/17 17:30
- dd-mm-yyyy e.g. 01-01-2017
- hh:mm:ss AM/PM e.g. 05:30:59 PM
Formatting Duration (Time-Interval) values
The interface for formatting Duration values is shown above. As with the other data-types, you can specify a format-code to customize the displayed values. However, for Duration values, Vizard does NOT use the conventions followed in Spreadsheet tools. This is due to their inability to display a number higher than 31 for days. Instead, Vizard uses the following conventions to display time intervals.
- d : Displays the number of Days
- h : Displays hours as 0-23
- hh : Displays hours as 00-23
- m : Displays minutes as 0-59
- mm : Displays minutes as 00-59
- s : Displays seconds as 0-59
- ss : Displays seconds as 00-59
Commonly used Duration format-codes
Here are some of the commonly used format-codes for Durations:
- d days hh:mm:ss e.g. 4 days 11:23:58
- d days h hrs m mins s secs e.g. 4 days 11 hrs 23 mins 58 secs
- d”d” h”h” m”m” s”s” e.g. 4d 11h 23m 58s