Chris Gould

+1 - I've just spent ages trying to understand why the field isn't visible to me. "Is this an explore issue or an agent issue"? Would be good to see it, regardless of whether data exists or not.

Hi @...S O'Callaghan,Yes the formula definitely works, however, I need to function as a date. Not just a normal attribute field.

So I would like to apply ranges to it like you might with ticket created-date and ticket solved - date.

For example: show me the "New attribute" for This month

Hi everyone,

I'm hoping this is a obvious/simple solution.

I am trying to do some rough forecasting which looks at a date 90 days after the ticket is solved. I'd like the attribute to behave like a date attribute where I can apply ranges or ideally even split into weeks and months, however, I know the latter requires extra work.

Here is my code so far and I'm stumped as to why it's not appearing as a date.

DATE(DATE_FORMAT(DATE_ADD([Ticket solved - Date], "day", 90), "yyyy-MM-dd"))

Hi @... - just wondering if there has been any changes in regards to reporting on SMS messaging in explore?

We just used DATE_FIRST_FIX function to find the time the first call was made against a ticket ID, given a ticket can have multiple calls, DATE_FIRST_FIX was ideal.

We were able to nest this into a DATE_DIFF to find the length in time between the ticket creation and the first call. You can then aggregate any way you like as there is only one value provided per ticket ID.

@...,

I have been told by my ZD account manager that it's likely a Q4 (US FY) release.

How is this not a feature? I hope it has changed since this was posted.

Hi - is this still on track for delivery in H2 2021?