Filtering Data with IF THEN ELSE in Zendesk Explore
How do I filter results using the IF THEN ELSE function in Zendesk Explore?
Filtering results with the IF THEN ELSE function in Zendesk Explore involves removing the ELSE statement to only display true results. This method is useful for performing unique calculations or pre-processing data before adding it to a report.
For instance, you can filter a report to show only assignees with a first reply time over 10 minutes by using a formula likeIF (SUM(First reply time (min))>10 THEN [Assignee name] ENDIF. This approach ensures that only the desired data is included in your report, providing a focused view of specific metrics or attributes.
More related questions
What is the IF THEN ELSE function in Zendesk Explore?
The IF THEN ELSE function in Zendesk Explore is a versatile tool used for calculations, allowing you to filter, group, bucket, and relabel results based on specific conditions. Essentially, it tests a condition and returns a value depending on…
How can I use the IF THEN ELSE function to group results in Zendesk Explore?
You can use the IF THEN ELSE function in Zendesk Explore to group or bucket your results, which helps in relabeling, excluding, or segmenting data to highlight higher or lower values. For example, you can label results based on whether they are…
Can I nest multiple IF THEN ELSE functions in Zendesk Explore?
Yes, you can nest multiple IF THEN ELSE functions in Zendesk Explore to handle complex conditions. This is useful for creating several groups or filtering by different expressions. For example, you can use the ELIF expression to simplify your…
How can I label results based on conditions in Zendesk Explore?
In Zendesk Explore, you can label results based on conditions using the IF THEN ELSE function. This allows you to apply different labels depending on the outcome of a conditional expression. For instance, you can label whether results are above or…
What are some examples of filtering calculations by attribute in Zendesk Explore?
In Zendesk Explore, you can filter calculations by attribute using the IF THEN ELSE function to focus on specific attribute values. This is useful for performing calculations on one attribute value while showing original metric results or different…
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.
