Zendesk Explore offers several examples of how joined attributes can be used to enhance your reports. For instance, you can join the 'Day of week' and 'Hour' attributes to filter reports by business hours using the formula[Ticket created - Day of week] + " " + STRING([Ticket created - Hour])
.
Another example is joining 'Year' and 'Month' attributes for better sorting or visual enhancement, using the formulaSTRING([Ticket solved - Year]) + " " + [Ticket solved - Month]
. These examples demonstrate how joined attributes can be tailored to meet specific reporting needs.
Joining attributes in Zendesk Explore is a straightforward process that can enhance your reports. You can combine multiple attributes into one calculated attribute using a simple formula. For example, to join two attributes, you can use a formula…
Creating a combined attribute for custom fields in Zendesk Explore can be done using conditional logic. If you have custom drop-down fields like 'Category' and 'Subcategory', you can use the IF THEN ELSE function to join them based on specific…
Yes, you can format joined attributes in Zendesk Explore to display dates in a specific format. For instance, if you want to display a date as '2020-09', you can use the formula `[Ticket solved - Year] + "-" + DATE_FORMAT([Ticket solved -…
To combine two channels into one in Zendesk Explore, you can create a group attribute. For example, if you want to treat 'Web' and 'Email' as the same channel, you can create a custom group attribute based on your ticket channels. This allows you…
Unfortunately, Zendesk Explore does not support escaping double quotes in text strings directly. This can be challenging when trying to create hyperlinks or other text strings that require double quotes. In Explore, the function LINK is used…