HienT/support-kpi-dashboard
0
Check out the configuration reference at https://huggingface.co/docs/hub/spaces-config-reference
๐ Support KPI Dashboard Generator
A Streamlit-based web application that enables support leaders to generate actionable KPI reports from support ticket data. Upload a CSV file containing your team's ticket history, and the app will instantly calculate performance metrics, visualize trends, and generate a downloadable PDF summary report.
Metrics:
- Total tickets
- SLA % met
- Average resolution time
- Top 5 agents
- Priority breakdown
Built With:
- Streamlit
- pandas
- matplotlib
- fpdf
๐ Project Overview
This tool was built to simulate how senior support managers can automate team performance tracking and reporting. It is ideal for monthly operational reviews, SLA compliance checks, and agent productivity insights.
๐ฏ Features
- โ Upload support ticket CSV file
- ๐ Automatically calculates KPIs:
- Total tickets
- Open tickets
- Average resolution time
- SLA compliance %
- Top 5 agents by ticket volume
- Ticket distribution by priority
- ๐ Visual dashboards powered by
matplotliband Streamlit - ๐ One-click PDF report generation
- ๐ ๏ธ Built with open-source tools:
pandas,streamlit,matplotlib,fpdf
๐งช Sample Data
Use the included sample_tickets.csv to test the dashboard.
ticket_id,created_at,closed_at,priority,assigned_to,sla_met,status
1001,2024-01-01 09:00,2024-01-01 14:30,P2,Alice,true,Closed
1002,2024-01-02 10:00,2024-01-03 11:00,P1,Bob,false,Closed
1003,2024-01-04 08:00,2024-01-06 15:00,P3,Alice,true,Closed
1004,2024-01-05 12:00,,P2,Charlie,false,Open
1005,2024-01-06 09:30,2024-01-06 17:45,P1,Bob,true,Closed
1006,2024-01-07 13:00,,P3,Dana,false,In Progress
# Support KPI Dashboard Generator
## Created by:
Hien Ta | [LinkedIn](https://www.linkedin.com/in/hien-ta-msda)