Logical functions in Zendesk Explore allow you to evaluate conditions and make decisions within your formulas. The IF THEN ELSE function is a conditional expression that lets you specify actions based on whether a condition is true or false. You can also use AND, OR, and NOT to combine or negate conditions. For instance,IF ([Ticket channel]="Email") AND ([Submitter email]="fred@fredco.com") THEN [Ticket ID] ENDIF
returns tickets received via email from a specific address. These functions provide flexibility in analyzing and presenting your data.
Creating a custom metric in Zendesk Explore involves using functions to perform calculations and comparisons on your data. To start, open the formula editing window and either type the name of a function or click 'Add' under Functions to select…
Zendesk Explore provides several basic mathematical operators to perform calculations and connect text. These include addition (+), subtraction (-), multiplication (*), and division (/). You can also test equality with '=', inequality with '!=',…
Attribute functions in Zendesk Explore help you perform operations on the attributes in your reports. Functions like COUNTVALUES and DCOUNTVALUES count the number of values or distinct values of an attribute, respectively. ATTRIBUTE_FIX and…
Tag functions in Zendesk Explore are designed to search for the presence or absence of tags in your data. Functions like INCLUDESALL and INCLUDESANY check if all or any specified tags are present in a tag attribute. For example,…
Zendesk Explore offers a variety of text functions to search, evaluate, and modify text. Functions like CONTAINS, LEFTPART, and LENGTH help you analyze text attributes, while REPLACE and TRIM allow you to modify text by replacing or removing…
Regex functions in Zendesk Explore allow you to perform complex text searches and modifications using regular expressions. Functions like REGEXPMATCH and REGEXPREPLACE enable you to match patterns and replace text based on regex criteria. For…
Zendesk Explore provides a comprehensive set of date functions to create, compare, and calculate dates and times. Functions like DATE, DATEEQUAL, and DATEDIFF help you work with date attributes, while TODAY and NOW return the current date and…