Difference with views and queries

Answered

2 Comments

  • Official comment
    Eric G. Gao
    Comment actions Permalink

    Hi Michael,

    Thanks for taking part in our AMA!

    While Views are often great for validating data in queries (and vice-versa), there are a few caveats in both tools that might cause some discrepancy between the two sources.

    For Views, any Archived Tickets (tickets that have been closed for more than 120 days) would be excluded.

    For Explore, there are two specific tag-based caveats:

    1. It does not currently handle the OR logic (returning tickets that has either Tag 1 or Tag 2). But it does handle AND logic nicely.

    2. It does not currently handle the exclusion logic (returning tickets without a specific tag) due to the way tags are stored in Explore. However, we do offer a nifty workaround, which enables you to calculate the number of tickets without a specific tag, by using [total number of tickets] - [total number of tickets with a specific tag].

    Therefore the differences you are seeing between the two would likely come from one of the caveats above (especially when tags are involved). For tips on making tag-based queries more robust in Explore, we recommend checking out this detailed guide on tag reporting.

    Hope this helps Michael and let us know if you have any additional questions (:

    Cheers,

    Eric

  • Brett - Community Manager
    Comment actions Permalink

    Explore Recipes AMA has ended and comments have now been closed. If you have any Explore recipe related questions, you can create a new post in our Explore - Troubleshooting and Q&A topic!

    0

Post is closed for comments.

Powered by Zendesk