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

# Multiple Measures Waterfall Chart

 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 Of High Med Low Total High - Found High - Finished High - Changed Med - Found Med - Finished Med - Changed Low - Found Low - Finished Low - Changed 2016 1 18 46 65 0 0 0 0 0 0 0 0 0 2017 0 24 78 102 0 -1 0 6 0 0 32 0 0 2018 0 23 77 100 0 0 0 14 -13 -2 123 -126 2

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.

• ###### 1. Re: Multiple Measures Waterfall Chart

Hi Ted,

To draw a Waterfall chart in Tableau

would require a special data structure

(as evident from the examples).

But with the proper data structure,

everything else is quite simple, i guess.