Explore recipe: Converting between metrics and attributes

Return to top

4 Comments

  • Anton Verhelst

    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
  • 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
  • Damien Messé

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

    0
  • 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.

Powered by Zendesk