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 like[Attribute A] + "-" + [Attribute B]
. This will concatenate the two attributes with a dash in between. However, be aware that if any attribute contains a NULL value, the result will also be NULL.
To create a combined attribute, start by opening a new report with the required dataset. Then, in the calculations menu, select 'Standard calculated attribute'. Name your attribute and enter the formula in the formula field. For more detailed steps, you can refer to the originalZendesk help article.
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…
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…