I would like to have a table-style report that shows each ticket where the ticket requestor has more than 1 open ticket. This will help our organization track down duplicate issues more easily.
I have two reports already created, one that should filter by requester email, and the other by organization name (that way if two different requesters from the same organization reach out, we should see that listed). The reports already group the requesters or organizations together and use a single merged cell for that column, but I'm having a hard time finding a way to hide the lines where the requester or organization have only 1 ticket. Here is a screenshot (with the ticket information redacted) showing what I have so far. You can see the lines that share a single cell for "Requester email", those are the online lines I would like to keep. Any help would be greatly appreciated!
In order to only show requester that have more than 2 ticket open, I would recommend using a metric filter to get only requesters with more than 2 tickets.
More information about the metric filter option in our documentation : Selecting the metric result range.
Best,