Recent searches


No recent searches

Tracking time spent in two custom field values

Answered


Posted Oct 16, 2023

I need to monitor the total duration for which all tickets had two specific custom field values simultaneously.

Specifically, I want to track how long tickets had the value `In Investigation` in the custom field named `Issue Status`, while also having the value `No` in another custom field named `Pending Status`.

How can I achieve this?


0

3

3 comments

image avatar

Elaine

Zendesk Customer Care

Hi Jan,

You can use this article to obtain the necessary data for measuring the duration of a specific ticket field value. To filter for tickets in a "Pending" status, add an attribute to the filter and select "no" as the value. This approach should help you gather the desired information.

I hope that helps!

0


Hi Elaine,

Thank you for your response. I've reviewed the article you mentioned. If I follow your approach, won't it filter for tickets that currently have the Pending Status value of No and then show the duration these tickets were under the custom field Issue Status with the value In Investigation?

What I'm aiming for is to determine the time all tickets (regardless of their current status) spent with both the Pending Status value of No and the Issue Status value of In Investigation simultaneously.


I would have thought I need to include both conditions in the standard calculated metric itself somehow, to account for time spent with both custom field values assigned at the same time?

0


image avatar

Alex Zheng

Zendesk Customer Care

Hey Jan,
 
You are correct that it will not filter for both values at the same time, I believe this is currently a limitation with the Explore functions and that we can only find this time spent for a single field at a time. I would highly recommend making a post for our product team on our feedback forums here.

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post