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

Avec réponse
image avatar

Greg Choisser

Publication le 09 nov. 2022

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

0 commentaire

Date
    Les plus récentes

      Vous connecter pour laisser un commentaire.

      Vous ne trouvez pas ce que vous cherchez ?

      Nouvelle publication