The data needs to be pivoted.
Then need to define end date.
I temporally put 7 days interval in each phase.
[Pivot field values (copy)]
if attr([Pivot field names])="Phase 4 Start"
then 30 ELSE lookup(min([Pivot field values]),1)-min([Pivot field values])-7 END
To put today, I created calculated filed
and put today as reference line.
Guntt_today_9.3.twbx 10.5 KB
1 of 1 people found this helpful
Under (1) and the following picture: "Pivot is available only for non-legacy Microsoft Excel and text file data sources."