Hello Apologies in advance as I thought I could do a simple time series report without having to do too much work but here goes..I was hoping I didn't have to create in Performance Analytics?
We have a Portofolio with 4 programs went live 9/8 and the last planned end date is tomorrow on project tasks
Since the project tasks all had a planned end date of every Thursday (9/18, 9/25, oct 9,16,23, 30 and nov6, 13 &20) the manager wants to see what tasks were overdue for that week (every friday so sept 19 &26, oct 3, 10, 17, 24 31 & nov 7 14 21)
the Manager wants a weekly trend count total and by program
I have a dashboard and know that we have approx 251 project tasks due right now not including the ones that will be overdue after EOD today..
see attached screenshot do I need to add something to the configure function field?
any help greatly appreciated!
Data=table=pm_project task
type=time series and column
report details
group by top program
trend by=planned end date
calendar =standard
per week aggregation=count
