Formatting insight axes

PostHog renders insights with a built-in axis formatter. Use it instead of contorting the query or a literal prefix/postfix to fake units.

The two insight kinds configure it in different places:

• TrendsQuery — trendsFilter.aggregationAxisFormat (this page, below)
• SQL insights (DataVisualizationNode) — per-column settings.formatting (see SQL insights)

The anti-pattern

If you are reaching for any of these, stop and pick a format below first:

• formula: "A / 60" with aggregationAxisPostfix: " mins" — manual seconds -> minutes
• formula: "A / 1000" with aggregationAxisPostfix: " s" — manual ms -> seconds
• formula: "A * 100" with aggregationAxisPostfix: "%" — manual ratio -> percent
• aggregationAxisPostfix: "ms" / "s" / "min" / "hr" on raw values