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.
Thanks very much in advance.
Are you still hoping for help with this question? If so, please let us know and we can try to help. A packaged workbook showing what you've already tried would be ideal.
P.S. If you've already found a solution, please share!