There are two types of numbers in Vitara Charts
Actual data numbers
Microstrategy delivers metrics with metadata that includes the format string and metric type.
The metric type is used to identify data values such as dates and percentages. Condensed format is identified via the Format string. Currency prefixes and suffixes (such as $/€). When the number format is set to automatic or custom, the date, scientific, and percentage metric types are displayed. In negative values, the following format is used: a minus symbol ‘-‘ or a pair of parenthesis ‘()’
Existing Functionality: MicroStrategy format string is used to identify percentage data. This is done regardless of the number format chosen in Microstrategy. When the % format string is specified, all data from the metric is assumed to be in percentage form. Aggregations made to metric data (through VitaraCharts menus) are updated as needed. All labels (data labels, axis labels, totals) and tooltips are properly formatted. Vitara Bar Chart Formatting (Formatted Values are shown in Microstrategy Grid Chart):
In all of the above instances, regardless of the metric’s Number Format, a formatted number (as seen in the Grid Chart) is utilised to denote the percentage data. Metric values are expressed as percentages in Data labels, Axis labels, and Tooltips.
In all the above screenshot, Formatted value(as shown in Grid Chart) shows ‘%’ even though the data is not in percentage form. Metric values in Data labels, Axis labels and Tooltips are incorrectly formatted as percentage.