You can report on user email domains in Zendesk Explore by creating calculated metrics and attributes. To do this, start by creating a new report and selecting the appropriate dataset. Add the necessary metrics, such as the number of tickets created, and then create a calculated attribute using the formulaREGEXP_EXTRACT([Requester email],"([^@]+)$")
to extract the domain from the email addresses. Finally, add this attribute to your report and apply any desired filters.
For more detailed steps, you can refer to the originalZendesk help article.
If your Zendesk Explore report hits the 50,000 rows error, it means the report is trying to process more data than the limit allows. This can happen when you have a large number of tickets, like 200,000, and the system processes the first 50,000…
Drillthrough does not work with calculated metrics and attributes in Zendesk Explore due to current limitations. When you attempt to use drillthrough, it may pull data for all clients instead of just the selected ones. To refine your results, you…
To create a calculated attribute for email domains in Zendesk Explore, use the formulaREGEXP_EXTRACT([Requester email],"[^@]+$")
. This formula extracts the domain part of the email address, allowing you to report on the domains from which your…
Yes, you can convert formulas from English to another language in Zendesk Explore, but be cautious as copying and pasting formulas directly may result in syntax errors. It's important to adjust the formula syntax according to the language settings…