I am trying to create a Gantt chart which should have been broken in Fiscal year (starting November of previous month) and so here it starts November 2016.
Also, every month doesn't show dates but instead broken into two parts - all dates upto 15th of the month Part 1 and rest Part 2
The hierarchy above the Gantt chart should thus look like - FY 2017, Year 2017, Month and lastly 1 or 2 for that Month.
Accordingly we will have the Projects and other details assigned
Can you help me how I can design this data source for tableau. Which columns it should have so I can show it correctly in my tableau
For Fiscal Year:
Right-click on the relevant date field under Dimensions in the Data pane,
Select Default Properties, Fiscal Year Start, November.
For Month Part, create a calculated field:
IF DAY([Date Field]) <= 15 THEN 'Part 1' ELSE 'Part 2' END
...and then drag that field to the columns shelf, to the right of the date pills.