DATE_DIFF() Between 2 Custom Attributes

+1

+1 

We have different custom fields and there are needs to be able to measure the time duration between two different custom attributes will be a great help.

+1

My instance is integrated with JIRA, and I’ve created custom attributes that return a timestamp when a custom field based on JIRA status is updated. To calculate the duration from the Open to Solve status in JIRA, I would need to use the date_diff formula between the two custom attributes timestamp

+1

Calculating two custom attributes will help me get the time difference between when the survey was sent and when it was rated.

+1

Hello Zendesk, Is there any update on when this will be available in Explore? I too have the need to get the difference between 2 custom attributes. 

Thank you for all your great feedback. The ability to calculate the time duration between two custom events that occurred during the lifecycle of the ticket can be very insightful.  Unfortunately, the current data model of the Updates history dataset and calculations functionality can not provide this functionality. 

While we would love to address this issue, we cannot work on it this year. 

Thanks Londa Cabrera you have an eagle eye!  :-). Unfortunately, I made a typo above (and not in the calculated metric definition).  The problem is still existing.

In parallel, Fabio from Zendesk Support connected with me and offered a workaround using "Liquid Markup" which I'll try.

Hello Fergus McCandless

It looks like there is a difference in your formula & that is probably the issue - 

DATE_DIFF(NOW(),[Ticket created - Timestamp],"nb_of_hours")

Hi Joanna Kime (Appamondo) - Thanks for your reply.  I've created it as a metric and now also as a calculated attribute but both don't generate any data and give the warning/err mentioned above (and below).

Failure to calculate SUM(Aging (hrs)) because the following values can't be evaluated: Ticket created - Timestamp.