The attached workbook should provide a starting point, although I struggle to correlate the data (Start Date and End Date) in your example XLS against the visuals you had created. Feel free to post further data - as Excel, or a revision to the attached - if this doesn't meet your needs.
Gantt sample.twbx 13.3 KB
Sorry for the late reply, and Thanks for the response in regard to Gantt chart, it really helped and I can make it perfectly.
I have one more question, in the same chart, on the date axis which is coming below, I need to show the dates for longer period e.g. I need to show all the tasks between (today - 4 weeks ) and (Today + 8 weeks) in future.
my Start Date falls in the cycle of = (today - 4 weeks ) and my end date falls in (today + 8 weeks )
but on the axis in the chart, I am not sure how to display -4 weeks & +8 weeks.
Any Idea ?
Thanks for all the help in advance.
Are you able to post a TWBX with sample data? It's much easier to work on the problem if I can see it in Tableau itself.
Is this an option?
Thanks for the reply Guy,
Here is the data in excel sheet,
and I can attach the screenshot of the dashboard.
In this, Date on the x-axis is start date, I need to show the
1. I need to show the calender dates which falls in (-4 Week) & (+8 Week) , also needs to show the week number which
2. also needs to show the week number on the same axis, so that Gantt chart shows the Date and week together on same axis.(if possible at all)
Data_PT.xlsx 11.3 KB