Hope this helps.
With adding "Name" as dimension to keep the table calc for Orange bar correct, the Start and End calculation is broken.
So, I added another set of Start and End bar calc.
Much appreciate your solution! If i may ask one more question... My final requirement is to filter the data displayed (not the underlying data) to last 6 months. How can i add a filter to achieve this?
I have experimented with examples such as Filter a View Without Filtering Underlying Data in Tableau to no avail.
1 of 1 people found this helpful
Unless you manually "hide" old months, I could not find dynamic way without having the drawback described below.
Looks like if there is no data, the dynamic filter does not work.