Connecting Data Tables in Zendesk Explore
How do data tables connect in Zendesk Explore?
In Zendesk Explore, data tables connect using the LEFT JOIN method, which ensures all rows from the left table are included, even if there are no matches in the right table.
This connection method allows for comprehensive reporting by joining tables based on unique identifiers, such as Ticket ID or Requester ID, to provide a complete view of your data.
More related questions
What are Zendesk Explore datasets?
Zendesk Explore datasets are collections of metrics and attributes used to create reports. Each dataset is specific to a product and must be selected before report creation. These datasets help you analyze various aspects of your business, such as…
How are Zendesk Explore datasets structured?
Zendesk Explore datasets are structured using multiple data tables connected by unique identifiers. This structure helps in efficient data querying and avoids duplication. Data tables are joined using connection points, like Ticket ID for tickets…
What default datasets are available in Zendesk Explore?
Zendesk Explore offers several default datasets, each tailored to specific products like Support, Guide, and Talk. These datasets include metrics and attributes relevant to their respective areas. For instance, the Support dataset includes ticket…
Can I use custom fields in Zendesk Explore datasets?
Using custom fields in Zendesk Explore datasets can be challenging, as they may not be directly available. If you're trying to use custom fields in a specific dataset, like the Sales database, you might need to explore alternative methods or…
Why do solved ticket metrics differ between datasets?
Solved ticket metrics may differ between the Tickets and Ticket Updates datasets due to the way data is recorded and updated. The Tickets dataset might show a different value than the Ticket Updates dataset because they track different aspects of…
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.
