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!
Please sign in to leave a comment.