Using Wildcards in Zendesk Explore Formulas
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 [ticket_ID] ENDIF. Other useful text functions include CONTAINS, ENDSWITH, and FIND, which help you search and manipulate text within your formulas.
More related questions
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…
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'…
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.
