Hi Explore team,
I was running data & metric definition comparisons between Explore and Insights as we strive to replicate our reports in Explore.
I came across a pretty important distinction in the # Tickets Metric.
Insights (GoodData) defines it as:
SELECT COUNT(Ticket Id, TicketTagId) WHERE Ticket Status <> Deleted AND Ticket Tag Deleted Flag <> true
Explore defines it as:
This means that when Explore counts # Tickets, it's a fundamentally different evaluation as it is counting Deleted Tickets. I've made a calculated Metric to mirror what Insights (correctly, IMO) evaluates.
IF ([Ticket Status]) != "Deleted" THEN [Ticket ID] ENDIF
Deleted tickets should never be counted unless specifically included in the metric or query.
Can the # Tickets metric in Explore be updated to match the Insights metric by default?
Thanks for considering!
Please sign in to leave a comment.