Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Metric defination to calculate the time taken at each substate

khareakshay
Tera Expert

I have a requirement to create metric defination to calculate the time spent at each sub-state of a record but I have to exclude those records where parent_request.u_GEMV2_request is false. parent_request is a reference field on a record pointing to its parent record while u_GEMV2_request is a boolean field.

 

I have already created metric defination but how to exclude the records as per above condition?

1 REPLY 1

Ankur Bawiskar
Tera Patron

@khareakshay 

check this

Create metric definition to calculate total time taken excluding on hold duration 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader