We managed to export the data from Zendesk to our data warehouse to build some reports in our Business Intelligence tool, and we are facing couple of data discrepancies we would like to understand.
In Explore, we would like to get the number of tickets solved by agent on a monthly basis (assignee).
When we apply [Ticket Created] date as a dimension in the rows, we get different numbers than when we apply [Ticket Solved] date as a dimension.
Could you clarify us if it's normal and if yes what's the best way to measure this metric?
Please sign in to leave a comment.