Thanks for your quick response. I had a look through the workbook and I think it may have an answer.
You've used time as the indicator to switch measures in the calculated field. I couldn't figure out what my equivalent would be, given that the measures I want to waterfall all exist in the same time period. Is it possible to create a dummy variable with the number of drivers in place of time within Tableau? If not, I can give it a shot by joining a dummy data set (think that might work).
Is there a more elegant way of doing that? I tried using Measure Name in place of time in your calculation, but it seems that field is not accessible when defining calcs (makes sense).
I've attached an excel with the same data and how I would approach it in excel, in case that helps. I have also added the data as it would be structured to your example and created the bars that I would like to waterfall.
Thanks for your help
I looked at your solution and tried to implement it on a report of mine, but feel like I wasted my time. You're looking at measures in different periods so this graph is nonsensical. The measures are just examples, but in effect what we're saying is something like Sales in Q1 less Costs in Q2 equals profit in Q3. Or am I missing something?
I've got one record per day and want to create a daily waterfall showing yesterday's production. My measures are say [Ore extracted], [ore trammed], [ore submitted to smelter] each describing a process that one resource go through, and I want to see the wastage on a waterfall every day. Is there actually a solution without changing the structure of my DB?
I want to create the same waterfall. Do u have any idea on the same, wer you able to achieve.
I have the exact requirement in this post:
Please assist. Thanks!
Can you please help me in making the Waterfall as explained in this post?
It would be really great of you if you can help me in this. Let me know if the requirement is not clear from the above post.
If you have 8-10 columns, you can piece together multiple sheets to create a multi-measure waterfall.
1) you have to be careful how you calc the 'blank base'... if the measure breaks across the zero line, you have to separate the calc above and below zero.
2) create a calc'd field that takes the max of each sheet's value and another for the min of each sheet's value (in case of negatives). Use these fields as blank reference lines to set the scale for each chart.
3) floating the pieces together onto a dashboard allows you to use the x, y, w, h coords to line everything up with precision.
An example is attached... note, I didn't take the time to complete all of the logical calc's... just did enough to illustrate the point.
MultiMeasureWFall.twbx 1.5 MB
Is it possible to create your method of waterfall with unique axis, since my data in live and viewed for different date ranges it would be better to have a relativity between the axes of each bar sheet.
Hi Praveen -
A waterfall chart is normally used to represent the pieceparts of a running sum... not sure what a waterfall with unique axes would look like... do you have an example you can share? It might be best to post to a separate thread.
Also, here's another thread with a scaffold approach to waterfalls.
I sorted it out, actually I made a mistake of having manual axis instead of automatic. And your example helped me a lot.