최근 검색
최근 검색 없음

Dustin Suits
가입한 날짜: 2021년 4월 15일
·
마지막 활동: 2021년 10월 16일
팔로잉
0
팔로워
0
총 활동 수
3
투표 수
0
가입 플랜
1
활동 개요
배지
문서
게시물
커뮤니티 댓글
문서 댓글
활동 개요
님의 최근 활동 Dustin Suits
Dustin Suits님이 에 댓글을 입력함
Hello @..., yes that is correct! We're trying to figure out how often tickets are being assigned to a group and someone outside of that group is solving. This would help us identify how often tickets are being assigned to this group incorrectly or how long this group spent on tickets without being the one to solve it. Thank you!
댓글 보기 · 2021년 2월 15일에 게시됨 · Dustin Suits
0
팔로워
0
투표 수
0
댓글
Dustin Suits님이 에 댓글을 입력함
If my organization has dozens of groups, how can I calculate the total number of tickets that were assigned to a specific group (and solved by any group)? I have tried the following formulas, filtering them to tickets created in 2021 for easier verification.
Formula 1 - Seems like the logical option for organizations with a large number of zendesk groups, but displayed a wildly inaccurate number in the single digits.
IF ([Changes - Field name] = "group_id" AND
[Changes - Previous value] = ANY AND
[Changes - New value] = "999xxx") THEN
[Update ID]
ENDIF
Attempt 2 - The outputted value was wildly inflated. I also would prefer not to use this method because it would require adding each group ID individually and it would remain a static list requiring manual updating if new groups are created.
IF ([Changes - Field name] = "group_id" AND
([Changes - Previous value] = "1xxxxx" OR
[Changes - Previous value] = "12xxxx" OR
[Changes - Previous value] = "123xxx" OR
[Changes - Previous value] = "1234xx" OR
[Changes - Previous value] = "12345x" )
AND
[Changes - New value] = "999xxx") THEN
[Update ID]
ENDIF
댓글 보기 · 2021년 1월 25일에 게시됨 · Dustin Suits
0
팔로워
2
투표 수
0
댓글