There is a large discrepancy between Explore and a third-party reporting tool that our company uses.
Zendesk is not able to troubleshoot third-party reporting tools, so it is important to keep in mind what your Explore query is set up to measure. Sometimes the definition of a metric or attribute might seem obvious, but there can be some nuance to it. For example, Tickets Solved are slightly different than Solved Tickets.
Often times what looks like a discrepancy can actually be explained by the chosen metric or attribute measuring something different than you are intending.
See these resources for more information: