Skip to content
Vega-Lite templates

ARR Bridge (Vega-Lite)

Opening to closing annual recurring revenue broken into new, expansion, uplift, downgrade and churn, giving 99.8 percent net retention.

Template previewVega-Lite
Rendering…

Make it your own.

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "title": "ARR bridge FY25 (GBP million)",
  "data": {
    "values": [
      {"step": "Opening ARR", "value": 42.6, "kind": "Balance"},
      {"step": "New business", "value": 9.4, "kind": "Growth"},
      {"step": "Expansion", "value": 5.1, "kind": "Growth"},
      {"step": "Price uplift", "value": 1.8, "kind": "Growth"},
      {"step": "Downgrades", "value": -2.3, "kind": "Contraction"},
      {"step": "Churn", "value": -4.7, "kind": "Contraction"},
      {"step": "Closing ARR", "value": 51.9, "kind": "Balance"}
    ]
  },
  "mark": "bar",
  "encoding": {
    "x": {"field": "step", "type": "nominal", "sort": null, "title": null, "axis": {"labelAngle": -30}},
    "y": {"field": "value", "type": "quantitative", "title": "GBP million"},
    "color": {
      "field": "kind", "type": "nominal", "title": null,
      "scale": {"domain": ["Balance", "Growth", "Contraction"], "range": ["#0ea5e9", "#22c55e", "#ef4444"]}
    },
    "tooltip": [
      {"field": "step", "type": "nominal"},
      {"field": "value", "type": "quantitative", "title": "GBP million"}
    ]
  }
}