Override Metric Format in Child Workspaces (Currency Focus)

You can override metric formats in child workspaces, allowing each workspace to apply its own number or currency formatting. This enables localized reporting and more flexible workspace customization, which is especially useful when different regions require formats such as $#,###.00, ¥#,##0, or other regional currency formats.

How It Works

Metrics can include a new metricType: CURRENCY property. Child workspaces can define format overrides using a new workspace setting called MetricFormatOverride.

If a metric has an explicit format, that format always takes priority. If it does not, the platform can use the workspace override based on metricType.

Example Scenario

Assume two tenants use the same curated analytics from a parent workspace. One tenant is in the US and wants currency values in USD, and the other is in the EU and wants currency values in EUR.

1. An analytics engineer marks the shared metric (for example Total Revenue) with metricType: CURRENCY in the parent workspace.
2. In the US tenant’s workspace (child workspace), set the currency override to a USD format (for example $#,##0.00).
3. In the EU tenant’s workspace (child workspace), set the currency override to a EUR format (for example €#,##0.00).
4. When users open reports in each child workspace, the same metric is displayed using the workspace’s local currency format (USD in the US tenant, EUR in the EU tenant).

Format Priority

Format priority follows the standard order:

metric format → user → user group → child workspace → parent workspace → organization

• Only format is defined → use metric format
• Only metricType is defined → use workspace override for that type
• Both format and metricType are defined → use metric format (ignore override)
• Neither → use workspace UNSPECIFIED override (if set)

MetricFormatOverride Setting

Example:

{
  "formats": {
    "CURRENCY": "¥#,##0"
  }
}

Analytics as Code

You can set the metric type in the metric definition. Supported values are CURRENCY and UNSPECIFIED.

YAML example:

type: metric
id: total_revenue
title: Total Revenue
maql: SELECT SUM({fact/revenue})
format: "$#,##0.00"
metric_type: CURRENCY