Some tickets are escalated using a checkbox in our ticket fields.
I would like to run a report where I can see for each month, how many tickets were updated, that initially did NOT have the checkbox ticked, but were submitted WITH the checkbox ticked.
This needs to be deduplicated, i.e. a ticket that was submitted now with the checkbox ticked, and updated again 10x that month while having the checkbox still on, should only be counted as 1.
Could somebody help me how to set this up in Explore?
Please sign in to leave a comment.