Automate Provision throughput reporting
Background
To help track provision team efficiency @courtmeddaugh has been putting together a spreadsheet of weight of issues closed vs projected weights normalized for team PTO. While this is a very useful report to have, it is a manual process to put together, if we're going to continue to depend on it we should automate the process of generating the data to be more efficient in measuring our efficiency.
Report inputs
- PTO report from Deel, aggregated at a team level
- Issue weights are drawn from Gitlab
Report outputs
- Table showing team wide summary per milestone of:
- Total PTO / working days
- Projected weight closed based on working days
- Actual weight closed
- Average weight per day / average days to close 1 weight
Edited by Courtney Meddaugh