Hi Tableau Users,

Our client wants to have a waterfall chart which the first column and last column in my Date Range Category ‘Now’ will show as a complete bar.

I have “Date start” and “Date End” parameter and here’s my category condition.

IF [Date]>=date([Date Start]) AND [Date]<=DATE([Date To]) THEN 'Now'

ELSEIF [Date]<date([Date Start]) then "Before"

ELSEIF [Date]>date([Date To]) then "After"

End

Here’s what I have done in tableau so far.

I used dual axis method. (First Metric is Bar Chart and 2^nd Metric is grant bar).

• For 1^st Metric - Bar: If attr([Date])>[Date Start] and attr([Date])<[Date To] then 0 else [Month End] END
• For 2^nd Metric -  Grant Bar: [Month End]

Main Concern:

My date range is from Jan 2015 to Dec 2015.

If the months selected in the Date parameter range (start and end) are available in the chart, it will give me the correct result.

But If I select a specific channel, the required waterfall chart will no longer achieve because my date start parameter and date end parameter is not available in the chart.

Provided the examples, I just want to ask for your any suggestions which I can show the full bar for the min Date and max Date in those data that will be categorized as ‘Now’

I have also provided my sample workbook here.

Thank you!

Regards,

Mads