Fergus McCandless

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.

Hi Joanna Kime - 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.

Is it possible to use the DATE_DIFF function using Today() or Now() as one of the date/time fields for comparison with a standard Zendesk field ie. [Ticket created - Timestamp]?

When I create the calculated metric ZD Explore accepts the syntax but later displays an err when running the report.

Example:
DATE_DIFF(NOW(),[Ticket created - Timestamp],"no_of_hrs" )

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

+1

I was very surprised this was not available already and hadn't been raised by other customers of Zendesk.  Please add this feature.