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.

Need duration of tasks from creation time to first assignment to a user as a report

Mahesh Kumar2
Tera Expert

I want to capture the duration of a task on RITM from creation time to first assigned to some user via metrics or something. Please help on the same

1 ACCEPTED SOLUTION

Mahesh Kumar2
Tera Expert

Achieved it through metrics by calculating the time difference.

View solution in original post

5 REPLIES 5

suvro
Mega Sage

Explore metrics you will find a way to do that. OR else create a duration type field in RITM table.

 

Write a Business Rule, when assigned_to changes and the duration type field you created is null.

then use the below community thread for setting the duration

https://community.servicenow.com/community?id=community_question&sys_id=0da20f21dbd8dbc01dcaf3231f961917

Hi suvro, i need it on task, not on RITM

Mahesh Kumar2
Tera Expert

Achieved it through metrics by calculating the time difference.

I need exactly the same - can you explain which metrics you have created and how you got it to work? 
Thanks.