Referência de funções do Explore



image avatar

Rob Stack

Zendesk Documentation Team

Editado 05 de mar. de 2025


3

0

53 comentários

Hi Team,

I am looking for a solution to concatenate multiple answers.

When I use Multi-select field and customer chooses more than 2 answers, it will show 2 lines in an Explore report.
I would like to show as 1 line = 1 ticket in the report.
Is that possible to make it with "Standard Calculated metric" or any other solutions?
Thank you for your support.

 

0


How can I create a query that would measure the amount (average) of characters per 1st comment in a submitted ticket? Anything I try comes back with en error.

 

0


Thank you, Dainne Lucena. Is there a plan to have this as a native function? This is a really bad customer experience. I would expect to be able to choose what time/date format I need. 

 

0


Hi 6220810130714 

You can try & create a custom calculated metric that mimics the Full Time Resolution metric which converts minutes to seconds. Once it's converted into seconds, you can then edit the display format to Duration. “Duration” convert your results into the hh:mm:ss format (hours, minutes, seconds). This format can be used only for metrics recorded in seconds. This is why you need create a custom metric in the form of seconds.



0


Hello, I am pretty new in this. 

I am trying to build very simple report. I need new metric “Median Full resolution time” but I do not want to see it in minutes but in the format “hh:mm” How can I do that? 

MED(Full resolution time (min)) 

I found only SECONDS_TO_TIME(_time) which should convert second to that but I need to covert minutes. On top of that I am not even sure how to write those formulas


 

0


Hi Chetan,
 

Someone from our team is already assisting you with your request on how to generate a report based on ticket age for each status. Reference ticket #12613567. We would suggest continuing and replying to the ticket if you have further clarifications and questions. Thank you!

0


HI Team,

What I want to do is 
I want to see Ticket Age for each status,
Eg: 1234 is the ticket number it was assigned to xyz and he kept it open I want age, if he change status from Open to pending i want to see what was the between open to pending. Similarly with other ticket's status

0


@Jacqui, I have created a proactive ticket so we can have a look at your specific use case. 

0


1263082140049

The DATE() function no longer works on text values. In fact the formula validator specifically says it requires numbers as input (though will accept the year as text), see screenshot below (using the example from this document).

While it allows me to pass a text formatted timestamp, I cannot then use the value given as a date in other date functions, such as date_format(), whereas previously it formatted these as expected.

0


1263797785409, thank you for pointing this out.

The DATE() function didn't work with the attributes only with values before. We made a change that allows it to work both with the values and attributes. Its purpose is to convert text values into a date with a timestamp. 

We haven't yet updated the function description yet, but we will do it both in the UI and this article. The new description will be: Converts the supplied text into a date with a timestamp.

The issues you mentioned are probably not related to this update but to the fact that we stopped executing reports with incorrectly configured formulas as mentioned in this announcement.

In most of the cases, the formula checker lets you know when there is a problem with the calculations but it can not predict all the cases. If you can not find a way to make your reports work please reach out to our support team.

0


Entrar para comentar.