Chart Type - Waterfall Chart

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 snippet to transform the data into a waterfall ready chart:

Title: waterfall_charts(table,value,order)

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]
Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like3 Follow
  • 3 Likes
  • 1 yr agoLast active
  • 918Views
  • 1 Following