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.

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
Kilo Patron
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.

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