Recent searches

No recent searches

Explore : How to create a date metric using the update date of a drop down field ?

Answered
image avatar

Jeremie Thomelin

Posted Dec 10, 2021

Hi all !

I want to know if something is possible or not in Zendesk Explore.

I have a drop down ticket field.I want to create a date metric in Zendesk that will give the update date of the ticket field for a specific value.

For example :
for the ticket field "Order status", I want to know the date when the value "Validated" have been selected.
It's important for me to have a date metric because I will then calculate the average time between two actions after that.

For Example :
DATE_DIFF([Order Validated - Date],[Start date - Date],"nb_of_days")

Is it possible ? if yes, any tips on how to do that ?

1

2

2 comments

Date
    image avatar

    Dave Dyson

    Hi Jeremie –
     
    Yes, that should be possible – take a look at Chandra Robrock's comment in this thread: Explore recipe: Recording the time when a checkbox was checked

    0

    image avatar

    Jeremie Thomelin

    Hi Dave,

    All right, thanks, I will have a look at it :) 

    0

    Please sign in to leave a comment.

    Didn't find what you're looking for?

    New post