Click to open in a new window

In Calxa charts you'll find a generic numbers format applied to the series labels or legend. Since KPIs can be a large range of numbers including ratio, percentages or dollar values you may want to improve the default number formatting from 4 decimal places to match the particular KPI you'll me reporting. 

In this video we'll take a look at the series labels number formats, but the logic can be applied to chart legends and other chart labels. 

Text Pattern

In this video you'll see that the Text Pattern property is updated to show different properties and formats on the chart labels. The list below shows available placeholders and a description. 

{S}Displays the name of the series. Budget or Actual for example. 
{A}Displays the series point argument. The monthly or quarterly period for example. 
{V}Displays the series point value. The numeric value of each series  point. 
{VP} Pie, Donut or Stacked series only. Displays series point value as a percentage.

Use a combination of the Text Patterns above to define what will be shown in the chart labels. For example a pair of placeholders can be specified together (e.g., {A} - {V}), will show both the argument and the value.

Format Specifiers

The value text pattern {V} can be combined with the above Format Specifiers to define the number formatting of the value. 

Format SpecifierDescriptionSampleOutput

Note that all of the Format Specifiers below should be combined with a numeric number that defines the number of decimal places shown. See the sample and output.  

CFormats the value as a currency amount with thousand separators.{VC2)$1,234.12
NFormats the value as a number with thousand separators. {VN1}1,234.1
PFormats the number as a percentage with thousand separators.{VP2}10.20%



Combining the Text Pattern and Format Specifiers you can define exactly what is displayed on the label. 

{A} - {VN0}June 2019 - 1,234
{A} {VN2}June 2019 1,234.12
{A}June 2019
{A}:{VC2}June 2019:$1,234.12