Understanding Explore Formulas in Zendesk
What are Explore formulas in Zendesk and how do they work?
Explore formulas in Zendesk are tools that allow you to create custom metrics and attributes for your reports. They help you perform comparisons, calculations, and data manipulations to present your business data effectively.
Formulas are constructed using metrics and attributes from your Zendesk data, combined with functions that perform operations on them. They follow the mathematical order of operations and can include multiple statements. Functions like IF/THEN are often used within parentheses to ensure they don't affect the rest of the formula. For more details, check out theoriginal documentation.
More related questions
How do I create a formula in Zendesk Explore?
Creating a formula in Zendesk Explore involves using metrics, attributes, and functions to define the data you want to analyze. To start, open a report in Explore and access the calculations menu. Choose 'Standard calculated attribute' to open a…
How can I add metrics and attributes to a formula in Explore?
Adding metrics and attributes to a formula in Explore is straightforward and essential for customizing your reports. In the formula window, click 'Select a field' to browse or search for the metric or attribute you need. Once selected, it will be…
What functions can I use in Zendesk Explore formulas?
Zendesk Explore offers a variety of functions to enhance your formulas, allowing for complex data analysis. To add a function, click 'Add' under Functions or type the function name directly. Explore provides auto-complete suggestions to help you…
How do I add comments to a formula in Zendesk Explore?
Adding comments to your formulas in Zendesk Explore is a great way to document your logic and collaborate with others. To add a comment, insert it within your formula using /* to start and */ to end the comment. Be cautious, as clicking 'Format'…
Can I use wildcards in Zendesk Explore formulas?
While Zendesk Explore doesn't support traditional wildcards, you can use text functions to achieve similar results. For instance, to filter countries starting with 'united', use the STARTSWITH function: IF STARTSWITH([Country], 'united') THEN…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
