Diego

Hi,

basically there is a crucial missing information here.

Zendesk improved the drill function but (also if you have previously enabled drill trough) the new capabilities needs to be activated in every dashboard, just as a shortcut follow these instructions to enable it:

Open your dashboard for editing.
Click Tab options > Interaction options ().
Select Enable drill in.

Have a nice day :)

@... Thank a lot for your response, I just pasted the formula but the query returns this error :/ do you know why?

@... Hi Taylor!

I have a similar problem as per Kamolchanok Jittrepit' s one.

I am trying to count Ticket IDs who changed the brand, I adapted the formula in this way (using brand IDs) but with no results.

IF ([Changes - Field name] = "Ticket brand" AND
[Changes - Previous value] = "301432" AND
[Changes - New value] = "3288609") THEN
[Ticket ID]
ENDIF

Do you have any suggestions?

Thanks and Ciao from Italy!

 

 

Unfortunately, seems not possible to color coding your query reports only but in tables, it would be a very appreciated feature especially for KPI format queries, 

 

Ciao from Italy!