formatting-insight-axes

Set trendsFilter.aggregationAxisFormat to "duration" for values in seconds or "duration_ms" for milliseconds. The formatter auto-picks friendly units per value, rendering 90 seconds as "1m 30s" without changing the underlying data.

For a 0-1 ratio from a formula like A / B, set aggregationAxisFormat to "percentage_scaled" so it renders as "47.3%". Use "percentage" only when values are already on a 0-100 scale, and never add a "%" postfix since the format appends the sign itself.

No. Dividing by 60 with a " mins" postfix freezes the unit at one scale and distorts further math. Use aggregationAxisFormat: "duration" instead, which keeps values in seconds and renders each label in the most readable unit.

SQL insights (DataVisualizationNode) have no trendsFilter; set formatting per column under chartSettings.yAxis[].settings.formatting with style "none", "number", "short", or "percent". The percent style multiplies by 100, so feed it a 0-1 ratio and leave suffix unset.

This happens when a percentage format is combined with a literal "%" postfix, or when percent style is applied to an already-scaled 0-100 column. Remove the postfix and pick one shape: ratio plus percent style, or 0-100 values with number style and a "%" suffix.

Use aggregationAxisFormat: "currency" when values are in the project's base currency. Use aggregationAxisPrefix: "$" with decimalPlaces when values are pinned to a specific currency like USD, so the symbol matches the data regardless of project settings.