KPI means Key Performance Indicator. In this instance, it refers to the performance of support groups through the data collected from a ticketing system.
The structure of this data is very specific, and as thus this program is written in a very specific way:
- Cases with owners
- Tasks with owners tied to Cases
- Correspondence with owners tied to Cases
When complete, I will provide sample input CSVs so that you can see how the output is formed.