Formats for Data Values

You can specify how values should be formatted for certain types of attributes in a model. Value formatting controls how the values appear to users in their BI tools. Setting the format preference in the AtScale model ensures that all BI users see the data values in the same way.

📄️ Number Format Strings

You can specify how number values are formatted for any metric or numeric-type dimension (INT, INTEGER, LONG, FLOAT, DOUBLE, or DECIMAL data types).

📄️ Boolean Format Strings

You can specify how values are formatted for attributes of BOOLEAN data types.

📄️ Date and Time Format Strings

You can specify how values are formatted for attributes of DATETIME or DATE data types.