Recent searches


No recent searches

Explore recipe: Converting between metrics and attributes



image avatar

Eugene Orman

Zendesk Product Manager

Edited Jun 21, 2024


1

4

4 comments

I've created a dropdown ticket field in support named star rating numbers. I want to calculate the average for the values (1 to 5) of this dropdown.

When I use NUMBER([star rating numbers]) I should be able to then add it as a metric and use AVG, but unfortunately, I get an abnormal result. Am I right in thinking that adding this Metric with the AVG aggregator should return the average of the dropdown values in all tickets?

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Anton,
 
We were able to replicate this behavior and the team is now looking into the issue with this function. Thanks for raising this with us! 
 
While we're working on a fix for this, a workaround that you can use for this kind of report is to add any date filter to the query. Here's a sample on my account: 

When I add a date filter – for example, Ticket created - Date – the query is able to calculate for the actual average from the metric values.

0


Hello, I have tried to convert a numeric field into an attribute using the function Value and I see this error : 

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Damien,
 
I created a ticket on your behalf so that we can investigate on this further within your account. Thanks!

0


Please sign in to leave a comment.