I've followed many simple Gantt chart tutorials but none assessed this issue.
I'm trying to display start and end years of various small businesses. I have put Start year in the Columns spot, calculated Duration (EndYear - StartYear) and placed that on Size and set Marks to Gantt.
The issue is that the bars are not aligning with Start and End correctly. The left-most end is aligned with (Start - Duration) and the right-most end is aligned with StartYear. The bars are going "backwards."
How do I make the beginning(left end) of the bar align with StartYear and the end(right end) of the bar align with EndYear?
We need data. Please attach your packaged workbook (**.twbx)
Only from the picture,
[Start Date] - [End Date] is based on "Day" // 1 = 1 day.
So to get "year" delta, right formula may be
Date diff('year',[Start Date],[End Date])*-1