Resource based trend report to show a weekly metric of open Vs closed by Resource

BijoyDeb
Tera Contributor

Hi All,

 

I want to create report for senior management which will show them a weekly metric of open Vs closed by Resource.

They need a table view of this like Pivot table report

Also, 

Will need this data grouped by Incidents , service Requests and stories. Open includes everything other than resolved / Closed.

 

PFA document which I want to show them as report exactly.

I was not sure how can we do this pivot type

Please let me know how can we do this?

 

 

BijoyDeb_0-1712146778997.png

 

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @BijoyDeb 

 

You can crate the Pivot in SN but not sure via trend its is possible. 

 

AGLearnNGrow_0-1712147138607.png

 

AGLearnNGrow_1-1712147192087.png

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************