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
Elaine
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
Jan Schweigerer
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 ofNo
and then show the duration these tickets were under the custom fieldIssue Status
with the valueIn 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 ofNo
and theIssue Status
value ofIn 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
Alex Zheng
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