Ticketing: canned Tickets report under Reporting > Customer Service

🔍 Problem Statement

As a support manager, I can't see a ticketing performance report in Pelcro like Zendesk's canned dashboards, which forces manual tracking of support performance.

💡 User Story

As a support manager, I want a predefined Tickets report under Reporting, so that I can monitor ticket volume, satisfaction, and response times at a glance for a chosen timeframe.
As a support manager, I want to see the CSAT responses customers submitted, so that I can understand the reasons behind the satisfaction score.
As a support manager, I want to export the report, so that I can share it outside Pelcro.

🎯 Definition of Done (DoD)

✔ Given the Reporting page, when a manager opens it, then a new Customer Service section contains a canned Tickets report.
✔ Given the Tickets report, when it loads, then it displays fixed widgets for ticket volume, tickets per status, satisfaction score, CSAT responses, median first-reply time, and median resolution time.
✔ Given the Tickets report, when a manager selects a timeframe (last 7, 30, 90 days, or custom range), then all widgets reflect tickets created within that timeframe.
✔ Given a selected timeframe, when the report loads, then the volume widget shows the total number of tickets created in that timeframe.
✔ Given a selected timeframe, when the report loads, then the status widget shows the ticket count and percentage per status (Open, Pending, On-hold, Solved).
✔ Given CSAT responses in the timeframe, when the report loads, then the satisfaction widget shows the score as Good ÷ (Good + Bad), with Good and Bad counts.
✔ Given CSAT responses in the timeframe, when the report loads, then the CSAT responses widget lists each response with ticket ID, customer, assignee, rating, comment, and submission date, newest first.
✔ Given a CSAT response in the list, when a manager clicks its ticket ID, then the related ticket opens in Ticket Details.
✔ Given tickets in the timeframe, when the report loads, then it shows median first-reply time (created → first agent reply) and median resolution time (created → first Solved).
✔ Given the Tickets report, when a manager clicks Export, then a CSV with all widget figures and the CSAT responses list for the selected timeframe is downloaded.
✔ This change will impact UI / API, specifically a new Customer Service section on the Reporting page and a reporting endpoint returning the report figures and CSAT responses by timeframe.