# Support Backlog and Resolution Report Local source edition 1.0.0. Turn an anonymous ticket snapshot into queue-level resolution times and an oldest-first backlog. Download queue metrics and open-ticket detail. ## Run locally Extract the complete ZIP. Use Python 3.12 from a terminal in the extracted directory. The tool uses the Python standard library. python run.py example.json results Use a new output folder for each run. Start with example.json and replace its synthetic values with your own data. Preserve field names, types and units. Files and reports are processed on your computer. ## Inputs Supply asOf and 1–3000 tickets from the same cutoff. Each row needs anonymous id and queue, status (open, in_progress, waiting, resolved or closed), created and resolved. Use a null resolved timestamp for currently unresolved tickets. For resolved or closed tickets use the latest resolution. All timestamps need seconds and an explicit offset. ## Results QUEUES.csv shows counts, the oldest open age, median resolution and nearest-rank 90th percentile. OPEN.csv lists current unresolved tickets by age. Times are elapsed calendar seconds from creation. Reported percentiles use resolved tickets only and are blank if none are resolved. No message text or customer information is needed. The results folder includes summary.json and the output files produced by this input. The sample produces: QUEUES.csv, OPEN.csv. ## Español · Informe de incidencias de soporte Calcula tiempos de resolución por cola y ordena las incidencias pendientes por antigüedad. Extrae el ZIP completo y abre una terminal en esa carpeta con Python 3.12. El programa usa la biblioteca estándar de Python. Ejecuta: python run.py example.json resultados Copia example.json para preparar tus datos. Conserva los nombres y tipos de los campos, usa una carpeta de salida nueva y consulta summary.json junto con los archivos generados. La descripción detallada de los campos está en inglés. The included LICENSE covers use and modification for your own personal and commercial projects. This edition includes its source and can run locally after setup.