1 of 1 people found this helpful
Hello Rajeshwari Guddeti,
Could you share a workbook that already contains this data? This appears to be possible to create a waterfall chart from using a the difference between rows and then using a running total of the difference for each value (making sure each value was negative for the running_sum(). The last calc - the one of productive time remaining is an assumed value and not one calculated based on a 0 for Calendar time on a day so that might be a bit tricky to see if we can do without changing the data.
Please let us know the version of Tableau in use and upload a workbook of sample data to let folks give this a try. It appears possible but that 0 for each day is what I expect to be challenging.
I hope this helps,
I'm trying to do the samething which is given in the tutorial but i'm not able to get the difference the way i'm looking for..
Can you please help me with this.. I'm using 10.1.4 version right now..
I'm not able to acheive the same using difference and running total..
In you case, you already prepared the data for the chart, then the chart needs to be aligned with your data structure.
The point here is you need to add grand total as sum of all code.
G.totla is little bit tricky, so if you ca prepare Total Productive field as excel basis calculated field, it becomes easier.
Anyways here, I created the charts according to your current data set.
Water fall (gantt) consiss of height and size.
if first()=last() then (sum(if [Allocation Code]="Unknown" then [Time available] end))
else sum([Time available]) end
if first()=last() then - sum(if [Allocation Code]="Unknown" then [Time available] end)
then -sum([Time available])
else -(ZN(SUM([Time available])) - LOOKUP(ZN(SUM([Time available])), -1))
waterfall_SM_9.3.twbx 14.0 KB
Hi Shinichiro Murakami
Please help me with your solution
if first() = last() then ....
how first() = Last()
I don't get the calculation
please help me out
This works perfect. But i'm also confused with the calculation. Can you please explain..
first()=last() can specify the G.total's behavior.
I try to find the official explanation, but could not find anything.
You can play around with the formula to find how the G.total number is chaging.