Trend report to show Active tasks per week for an assignment group

[Scott Stahr]

Is there a way to create a trend report that will show how many active tasks an assignment group has per week?  We want this report to show capacity and visualize which teams are struggling to complete the tasks that are assigned to them and where additional resources could be required.

[sachin_namjoshi]

Configure below report

Regards,

Sachin

[Scott Stahr]

Thanks Sachin, but that report will only show how many tasks were created per week, not how many were active at the end of that week.  If a team had 10 tickets open at the end of last week, have 5 new ones come in this week and closed 4 tickets during the week, I would want to show 11 for the current week, not 5.

[sachin_namjoshi · Accepted solution]

You will have to use performance analytics for this kind of report.

This is available OOB with performance analytics premium indicators.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

If you do not have PA, then you can configure custom chart to show type of report.

Regards,

Sachin

[Scott Stahr]

Thanks Sachin!  I was able to tweak an incident indicator to get the results I was looking for