CoolFace
Apppublic

HienT/support-kpi-dashboard

sourceHugging Facemitupdated 1y agoView on Hugging Face
0likes
App README

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 matplotlib and 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.

csv
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)