Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report for overdue Project tasks by week

mborkowski
Tera Contributor

Hello Apologies in advance as I thought I could do a simple trend report without having to do too much work but here goes..

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 a 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!

 

0 REPLIES 0