I am trying to filter Merged tickets from reports

Question

197 views Asked by bhagwat kushwaha At 08 October 2020 at 11:56

In reports. I am trying to filter Merged tickets from reports. And I am referring this solution,

does Zendesk made any changes in UI/Options because I am unable to find options showed in above post to add matric globally and By Using Query

 SELECT IFNULL((SELECT # Tickets WHERE Ticket Tag = your_tag),0)

Is there any other better way to remove merged tickets form Zendesk reports. Thanks in advance,

There are 1 answers

**Jonny Pabon** · Answer 1 · 2020-11-18 21:09:48

From what I understand, you'll want to build the metric yourself as none of that appears to be default. I will share a link to help you:

Oh and if the formula you have above is correct but by excluding the closed_by_merge tag would be the best way to exclude merge tickets.