Weeks in Gantt view
Posted: Fri Nov 04, 2011 11:29 amIs it possible to see week numbers in the Gantt instead of days?
You'll want to create a new calc field for this in the CalendarRows table--and make sure it is repeating, with 40 repetitions. Here is one version of such a calc:
- Code: Select all
Case (
not IsEmpty ( GanttDateDisplayCalc ) ; // is one of the columns showing a date
"W" & Right ( "0" & WeekOfYearFiscal ( GanttDateDisplayCalc + If ( Extend ( DateStartWeekOnMondayGlob ) = "No" ; 1 ) ; 2 ) ; 2 )
)
You can place this on the gantt tab above the day field that's there, or instead of it. You'll need to play with this a but as I don't think we have room to show 3 characters (the "w" and the week number) but this should get you started.
Hope that helps,
John