최근 검색


최근 검색 없음

Report for requestors who submitted 2 or more tickets



2023년 11월 16일에 게시됨

Was interested in creating a report that only shows requestors who have submitted 2 or more tickets and the ticket ID numbers for these requestors

Any help would be greatly appreciated!


1

2

댓글 2개

This is a great question; I've had similar thoughts myself and I'll be interested to see if anyone has any good ideas.

The only way I was able to get there was to pull a count of all tickets created within a given date range by Requester, then to apply a metric filter to only show Requesters with a count of 2 or more, and then to sort by ticket count in descending order.

Depending on the date range you're using, that alone could be a huge number of rows so it may not be possible to add the Ticket ID there. If you add Ticket ID and the report won't display, you should be able to export the results and view the whole list in a spreadsheet. Or you could make Ticket ID drillable, then you could click into the Ticket Count for each Requester to get a list of their Ticket IDs.

Hope that's useful and, again, interested to see if anyone else has other ideas! 

1


Hey,

we build this for our Brands :)

Works pretty well. Via result metric calculation you can choose only the users which more than one open ticket :)

0


댓글을 남기려면 로그인하세요.

원하는 정보를 못 찾으셨나요?

새 게시물