1 Reply Latest reply on Feb 10, 2019 11:35 AM by Yuriy Fal

    Multiple Measures Waterfall Chart

    Ted Daniels

      As of

      High

      Med

      Low

      Total

      2016

      1

      18

      46

      65

      2017

      0

      24

      78

      102

      Found

      0

      14

      123

      137

      Finished

      0

      (13)

      (126)

      (139)

      Changed

      0

      (2)

      2

      0

      2018

      0

      23

      77

      100

       

      Hello,

       

      I have the above data that functions like a balance sheet. Each year, there is a number of high, medium, and low priority items. Year to year, the amount of high, medium, and low priority items will change depending on the number of items found (added), finished (subtracted), or changed (could be either added or subtracted) in each category (high, med, low).

       

      I need to graph the number of items over time using a waterfall chart, but I'm not sure how to accomplish this in Tableau since I have multiple measures and was only given the above summary table.

       

      I represented the above table as the following for usage in Tableau (this is the whole dataset in my Tableau workbook)

       

                 

      As OfHighMedLowTotalHigh - FoundHigh - FinishedHigh - ChangedMed - FoundMed - FinishedMed - ChangedLow - FoundLow - FinishedLow - Changed
      20161184665000000000
      2017024781020-106003200
      20180237710000014-13-2123-1262

      I pivoted the table to have a found/finished/changed value for each item type and year, where the amount found/finished/changed for a given row is the amount that the previous year's/row's high/med/low changed by to get this year's/row's high/med/low items values.

       

      I've tried to represent the table as a waterfall chart with the high/med/low counts at each year and the found/finished/changed deltas between the successive years, but had not luck so far.

       

      All tutorials online have a single measure, and don't involve the plotting of multiple delta measures between years.

       

      Any help would be greatly appreciated. Thank you.