최근 검색

최근 검색 없음

Reporting on end-users with multiple requests of the same type

답변함
image avatar

Greg Choisser

2022년 11월 09일에 게시됨

I'm working on a report that would allow us to show requesters with <= 4 tickets with the same request type. I've tried using IF ([Ticket tags]="ticket_type_1")<=4 THEN "Follow Up" ENDIF and IF ([field name]="field_tag")<=4 THEN "Follow Up" ENDIF and calculating it on requester id. However, I'm not getting any results this way. Ideally, I'll be able to build this out with ELIF to include all the field tags under the field. 

IF ([Ticket tags]="ticket_type_1")<=4 THEN "Follow Up"

ELIF ([Ticket tags]="ticket_type_2")<=4 THEN "Follow Up"

etc. 

0

2

댓글 2개

날짜
    최신순
      image avatar

      Greg Choisser

      This worked perfectly!

      0

      image avatar

      Gab Guinto

      Hi Greg,

      Here's a different approach:
      You can start by creating a custom attribute to identify the request type based on tags. Example:
      IF (INCLUDES_ANY([Ticket tags], "ticket_type_1")) THEN "Type 1"
      ELIF (INCLUDES_ANY([Ticket tags], "ticket_type_1")) THEN "Type 2"
      ELIF ...
      ENDIF
      With the native Tickets metric, you can add this custom attribute under Rows to see a breakdown of tickets per request tag. You can then add Requester name to slice the data further by requester.
       
      Then, apply a metric filter to only show rows with a ticket count of 0 to 4. Your table should display requesters with 4 or less ticket per each request type. 
       
      Hope this helps. Thanks Greg!

      1

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

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

      새 게시물