Use PDIs? Take our 5-minute survey to help shape the PDI roadmap.

How to get assign to name from Task_sla table dot walking for reporting purpose

mmahaj01
Tera Contributor

How to get assign to name from Task_sla table dot walking for reporting purpose

2 ACCEPTED SOLUTIONS

It won't work in a report based on a Graph.
I see you're trying to create a trend report, but it's not picking up the "Assigned To" field correctly.

****************************************************************************************
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
******************************************************************************************

View solution in original post

Hi @mmahaj01 
As Atul mentioned, you can only select date/time fields under Trend by.
However if you want to see the Assigned to in X axis, they you can go with Bar graph.
Sample:

JSiva_0-1744869013088.png

 

View solution in original post

5 REPLIES 5

J Siva
Kilo Patron

Hi @mmahaj01 
Follow the below steps
1. Search for "task" and expand

JSiva_0-1744867663059.png

2. Select "Assigned to"

JSiva_2-1744867842152.png

Output:

JSiva_3-1744867884239.png

 

Hope this helps.
Regards,
Siva

 

mmahaj01
Tera Contributor

Thanks Siva for the update

But we want to use assigned to Name  in graph

mmahaj01_0-1744868206653.png

 

Please suggest



It won't work in a report based on a Graph.
I see you're trying to create a trend report, but it's not picking up the "Assigned To" field correctly.

****************************************************************************************
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
******************************************************************************************

Hi @mmahaj01 
As Atul mentioned, you can only select date/time fields under Trend by.
However if you want to see the Assigned to in X axis, they you can go with Bar graph.
Sample:

JSiva_0-1744869013088.png