Writing Explore formulas

Return to top
Have more questions? Submit a request


  • Katie Barton



    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]

Please sign in to leave a comment.

Powered by Zendesk