Waterfall charts are a beautiful way to show a positive and negative stack in series. This sums to a running total over the series of values. It allows a consumer to quickly see the rise and fall over the series so they can identify the points in the chain causing a large drop. This can also be a great way to display a KPI across another dimension.
For the two running total series, color = #f9f9f9
Set the negative series to red, a possible color = #fb3a2d
Use ord as x-axis, abs and running_total as y-axis, and sign as series
Here's a parameterized snippet to transform the data into a waterfall ready chart:
select [order] , abs([value]) , case when [value] > 0 then sum([value]) over(order by [order] rows between unbounded preceding and 1 preceding) else [value] + sum([value]) over(order by [order] rows between unbounded preceding and 1 preceding) end as running_total , case when [value] > 0 then 'positive' else 'negative' end as sign from [table]
Please sign in to leave a comment.