Skip to main content
Get Started
Documentation

Waterfall charts in Tractorscope

Waterfall charts show how a value changes from one step to the next. They are useful for explaining increases, decreases, and net change.

Common use cases

  • Revenue bridge
  • Profit and loss changes
  • Starting balance to ending balance
  • Customer count gained and lost
  • Budget variance

SQL shape

Return an ordered step and a numeric change value:
select 'Starting ARR' as step, 100000 as amount, 1 as sort_order
union all
select 'New business', 25000, 2
union all
select 'Expansion', 12000, 3
union all
select 'Churn', -8000, 4
order by sort_order
select 'Starting ARR' as step, 100000 as amount, 1 as sort_order
union all
select 'New business', 25000, 2
union all
select 'Expansion', 12000, 3
union all
select 'Churn', -8000, 4
order by sort_order

Setup tips

  • Keep step labels concise.
  • Use positive and negative colors that are easy to distinguish.
  • Use waterfall charts for explanation, not high-density reporting.

Related docs