Data Format

You can format AML fields to improve readability for your reports. This section will help you define a Data-Format-As-Code using AML.

Available formats include:

• Date Format
• Number Format

High-level conceptCopy Anchor Link

To format an AML dimension/measure, you will need to add a format property to the dimension/measure definition that contains a format pattern to this dimension/measure.

If your pattern is invalid, the renderer falls back to the default format to render your data.

Model public_accounts {
    type: 'table'
    label: 'Accounts'
    table_name: '\"public\".\"Accounts\"'
    data_source_name: "piggy_bank"

    dimension balance {
        label: "Balance"
        type: "number"
        definition: @sql {{ #SOURCE.balance }};;
        hidden: false
        format: "#,###0.00,,\"M\""
    }
}