Writing Explore formulas

Return to top
Have more questions? Submit a request

31 Comments

  • Katie Barton

    Hello,

     

    Restating this question from 5 months ago. I'm trying to replicate the following Insights custom metric in Explore and can't seem to get the formula correct. Any advice?

    Insights: SELECT AVG([Text Field] Duration in minutes)/60 WHERE Text Field = Group AND Ticket Status <> Deleted
     
    I tried creating a standard calculation in the Tickets dataset, but only got this far (without getting the green checkmark) 
     
    Explore: SELECT([Changes - Field name]AVG(Field changes time (hrs))) WHERE [Changes - Field name] = [Update ticket group]
    0

Please sign in to leave a comment.

Powered by Zendesk