[Project stage]="1"

The same data type should be used on both sides of the equality expression. A value wrapped in quotation marks is considered text, but a number without quotation marks is a number. BecauseProject stageis a text attribute, the value should have quotation marks.

[Ticket country]!=[User country name]

The same data type should be used on both sides of the inequality expression.Ticket countryis text, so the attribute on the right should be text too.

[Ticket assigned - Date] >= "2023-01-26"

The same data type should be used on both sides of the greater than or equal to expression. In this case, it’s a date wrapped in quotation marks.

[Ticket group]+STRING([Ticket ID])

The goal of this formula is to join text as showcased inExplore recipe: Joining attributes. That’s why the numeric attribute needs to be transformed into text via the STRING function.

VALUE(Full resolution time (min))+NUMBER([Additional task time])

The goal of this formula is to sum up two values.Full resolution time (min)is a number, butAdditional task timeis a text field with numeric values listed inside of it. The best approach is tocreate a new numeric custom field in Supportfor recoding the additional task time, which won’t require any transformation and will work "out of the box" in Explore. Alternatively, the text attribute can be transformed into a number via the NUMBER function.

VALUE(First reply time (min))/60

Arithmetic operations such as division require numeric values. A value wrapped in quotation marks is considered text, but a number without quotation marks is a number. The quotation marks shouldn’t be used here.

• IF [Ticket status]="Open" THEN 1 ELSE 0 ENDIF

  or

• IF [Ticket status]="Open" THEN "1" ELSE "0" ENDIF

The values used after the THEN and ELSE keywords should be of the same type. A value wrapped in quotation marks is considered text, but a number without quotation marks is a number. So there are two ways to fix this error, as shown above.

IF VALUE(Agent replies)=1 OR VALUE(Agent replies)=2 THEN [Ticket ID] ENDIF

Conditions set inside of the IF statement should be TRUE or FALSE. The correct syntax is: IF TRUE OR FALSE THEN [Ticket ID] ENDIFYou need to add some conditions, as shown above. (However, the formula editor doesn’t assess the validity of the conditions themselves.)

NUMBER([Ticket external ID])

The NUMBER function is designed to transform text attributes with numeric values into text. TheTicket IDattribute is a numeric field, which is why it can’t be used with this function. However, text attributes such asTicket external IDcan.

• LINK("https://subdomian.zendesk.com/agent/organizations/"+STRING([Ticket organisation ID]), [Ticket organisation name])

  or

• LINK("https://subdomian.zendesk.com/agent/organizations/"+STRING([Ticket organisation ID]), STRING([Organisation check box]))

The LINK function expects text as the second parameter, which is why you can’t use a boolean attribute. There are two options, as shown above. You can use a text attribute, or transform the boolean attribute to text via the STRING function.

DATE_LAST([Ticket created - Timestamp])

The DATE_LAST function expects a timestamp attribute.

开关([票集团]){案例“支持”:“1”3: "2" }

BecauseTicket group条件是一个文本属性,所有情况下都要吗d be of the text type. A value wrapped in quotation marks is considered text, but a number without quotation marks is a number. So the 3 needs to be wrapped in quotation marks.

开关([票集团]){案例“支持”:“1”"IT": "2" }

The results of all cases should be of the same type. A value wrapped in quotation marks is considered text, but a number without quotation marks is a number. So the 2 needs to be wrapped in quotation marks.