About the Formatted Column Element

The Formatted Column element is similar to other elements designed to extend the data available in a datalayer. Like the Calculated Column element, the Formatted Column is added as a child element beneath a datalayer and adds a new columnto the datalayer. This new column contains formatted data which is accessible using an @Data token.

Formatting data in the datalayer is particularly useful when working with charts, particularly Animated Charts, whose data attributes may not allow application of scripting functions or formats. In addition, Tooltips can also benefit from being able to use formatted data.

Note that data in a Formatted Column may not be of the same data type as the column from which it is derived. For example, when a numeric column, with a value of 1234, is used to create a Formatted Column that applies the Currencyformat, the result will be string-type data: "$1,234.00". Thus, in this case, the Formatted Column is useful for chart axis labels, but may not work for chart data, which requires the original numeric value.

The pre-configured format options available in the Formatted Column element are identical to the Format attribute value options in elements such as the Label. In addition, custom formatting can be entered manually.

For more information about formatting options and custom formats, see our document Formatting Data Document

Dynamic Formatting

The Formatted Column element has an Include Condition attribute: 

If the value of this attribute is left blank or contains a formula that evaluates to True, the element is applied to the datalayer. If the value evaluates to False, the element is ignored and does not affect the datalayer. This powerful feature allows developers to dynamically determine if a new column of formatted data will be added to the datalayer or not.