Getting two different results from the same query in Insights versus Explore | Community
Skip to main content

Getting two different results from the same query in Insights versus Explore

  • January 20, 2021
  • 1 reply
  • 0 views
J

Hi.

I'm a bit lost on why I'm getting two different sets of data from what is essentially the same query. I'd like to see all tickets that were solved in 1 touch or less. In Explore I'm using the following query:

 

Where I'm trying to replicate this metric

Even having included the "Closed" status in my Explore query I still receive a much lower value than my insights chart is displaying. I'm sorting the data by week. 

Any help here is appreciated!

    1 reply

    Marie-Cathrine

    Hi Jhalil,

    The Insights metric says <=1 whereas your Explore metrics says <1, this means that you're not including the tickets with one reply in your Explore metrics. Try changing it to <=1.

    I hope this helps.

    #helpsome regards,
    Marie-Cathrine Sørensen
    Developer @ helphouse.io

    Terms & ConditionsCookie settingsAccessibility statement