Recent searches


No recent searches

Bob Gaul's Avatar

Bob Gaul

Joined May 25, 2022

·

Last activity Aug 23, 2022

Following

0

Followers

0

Total activity

5

Votes

0

Subscriptions

2

ACTIVITY OVERVIEW

Latest activity by Bob Gaul

Bob Gaul created a post,

Post 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

Posted Aug 23, 2022 · Bob Gaul

1

Follower

4

Votes

1

Comment


Bob Gaul commented,

CommentPerforming calculations

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

View comment · Posted May 25, 2022 · Bob Gaul

0

Followers

0

Votes

0

Comments


Bob Gaul commented,

CommentPerforming 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?

View comment · Posted May 25, 2022 · Bob Gaul

0

Followers

0

Votes

0

Comments