This content has been marked as final. Show 1 reply
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|
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.