최근 검색


최근 검색 없음

Bob Gaul's Avatar

Bob Gaul

가입한 날짜: 2022년 5월 25일

·

마지막 활동: 2022년 8월 23일

팔로잉

0

팔로워

0

총 활동 수

5

투표 수

0

플랜 수

2

활동 개요

님의 최근 활동 Bob Gaul

Bob Gaul님이 에 게시물을 만듦

게시물 Q&A - Reporting and analytics

Hi,

I am trying to report on Skipped Tickets / Tickets sent back to queue by agents, doing so with a calculated attribute to show where an agent has changed the Assignee ID from their own to 0.

[Changes - Field name] = "Assignee ID"
AND [Changes - Previous value] = [Updater ID]
AND [Changes - New value] = 0

I receive the following error message:

The calculated attribute "unassignedbyagent-7503211c98" references "Changes" which is as an unknown attribute. Adjust the calculation and try again. (Error code: 7f666e2e).

Is there a way of calculating this?

 

Many thanks,

 

Bob

2022년 8월 23일에 게시됨 · Bob Gaul

1

팔로워

4

투표 수

1

댓글


Bob Gaul님이 에 댓글을 입력함

댓글Performing calculations

Thank you so much Erin O'Callaghan! I've no idea why I didn't think of that myself...

댓글 보기 · 2022년 5월 25일에 게시됨 · Bob Gaul

0

팔로워

0

투표 수

0

댓글


Bob Gaul님이 에 댓글을 입력함

댓글Performing calculations

Hi,

I am trying to add a column to a query to indicate whether an agent is an internal or external resource. This is defined by the assignee email address.

The following formula is showing an error message when trying to add this attribute:

IF (CONTAINS([Assignee email]]),"@example.com"))

THEN "External"

ELSE "Internal"

ENDIF

What can I do to correct this?

댓글 보기 · 2022년 5월 25일에 게시됨 · Bob Gaul

0

팔로워

0

투표 수

0

댓글