Top resolved issues by category
SQL query for Zendesk
Get the top resolved issues by category.
SELECT category, issue, COUNT(*) as resolved_count FROM zendesk_table WHERE status = ‘resolved’ GROUP BY category, issue ORDER BY resolved_count DESC
Zendesk data model
Users
Locales
Tickets
Organizations
Organization Memberships
Groups
Group Memberships
Organization Fields
Organization Subscriptions
User Fields
Ticket Skips
Suspended Tickets
Ticket Metrics
Ticket Events
Articles
Macros
Help Center Categories
Help Center Sections
Ticket Fields
Satisfaction Ratings
Ticket Forms
Tags
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed