Hi All,
I am creating a waterfall chart as shown in the screenshot below and would like to add the difference between the start and the end value in the chart as shown in the screenshot2. can anyone please let me know if there is a way to achieve this?
Note: I have attached the tableau file with dummy data for reference.
Thank you,
Naveen
hi @Naveen Voruganti
I have attached a workbook for the same. Will this fulfill your requirement?
Cal fields required,
axis : 8 for axis of dual axis
line: window_max(sum([measure value])+20) for controlling the primary axis
Difference cal:
{ exclude [measure_name]:
sum({ FIXED [measure_name]:SUM(if [measure_name]='KPI8' then [Measure_Value] else 0 END)}-
{ FIXED [measure_name]:SUM(if [measure_name]='KPI1' then [Measure_Value] else 0 END)})
}
