Metric defination to calculate the time taken at each substate
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
49m ago
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! 🙏
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader