Recent searches


No recent searches

Explore recipe: Reporting on tickets with an internal comment before a public comment



image avatar

Nhia Lor

Zendesk Customer Care

Edited Jun 21, 2024


0

4

4 comments

I keep getting this error at the Creation Step:

The set of calculations isn’t valid. The calculated attribute "SUM(firstinternalcommenttimestampconverted-0c0ea4c924)" references "First internal comment - Timestamp" which is as an unknown attribute. Adjust the calculation and try again. (Error code: 6e51fde7)

 

 

 

I also get this when I try to add a different metric.

The set of calculations isn’t valid. The calculated attribute "SUM(firstinternalcommenttimestamp-454293e016)" references "Update ticket ID" which is as an unknown attribute. Adjust the calculation and try again. (Error code: 6cd077cc)

Sorry, I have no idea what Im doing. :D

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi James,

Based on that error, it appears that you are creating the metric using a different dataset. Make sure that you are on the Updates history dataset.

0


I am getting the following errors when I am step 2 in the "To create the report" section. How can I fix this? 

The set of calculations isn’t valid. The calculated measure "SUM(ticketswithfirstinternalcommentbeforepubliccomment-4c814c077a)" references "First public agent comment - Timestamp (requesters_custom_field_253926" which is as an unknown metric. Adjust the calculation and try again. (Error code: c77e4bb4)

The set of calculations isn’t valid. The calculated measure "SUM(ticketswithfirstinternalcommentbeforepubliccomment-4c814c077a)" references "First public agent comment - Timestamp (requesters_custom_field_253926" which is as an unknown metric. Adjust the calculation and try again. (Error code: 08e59c8d)

0


image avatar

Alex Zheng

Zendesk Customer Care

Hey Sherin,
 
Generally this error occurs if you are in the wrong dataset, can you make sure that you are in the Updates History dataset?

0


Please sign in to leave a comment.