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.

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

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

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
Tera Sage

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.

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

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

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