Working with Tableau 10, I need to re-create the following gantt chart:-
The blue shading represents the bi-week range that the job was started in and the length of time it's currently active (using DATEDIFF).
My question is two-fold:
1) How can I represent continuous bi-weekly dates along the top based on 'start date'?
2) Taking job A1 as an example: If I have a parameter 'from' and 'to' and enter the 'from' date as 12-Sep (which is after it's start date of 3-Sep), this still needs to show as the job is still active. At present, if I select a date beyond the job's start date, it drops out from the chart.