Key Features • Planned Features • How To Use • Credits

• SLA Report
  • Returns you a .xlsx file containing the percentage of SLA tickets that were broken in the time of first response and resolution in a specific week or month. It also returns the amount of tickets resolved in its respective duration;
  • The .xlsx file has two sheets, one with information ordered by month and the other ordered by week. Each week starts at monday.
• Status Report
  • Returns you a .xlsx file containing the time duration of its respective Key status and the total amount of time of all status combined;
  • The .xlsx file has two sheets, one with only the resolved issues and the other with resolved and unresolved issues;

• Automated Email services.

To clone and run this application, you'll need Git and Python 3. From your command line:

# Clone this repository
$ git clone https://github.com/GabrielSSGF/Report-Generator-for-Jira

# Go into the repository
$ cd Report-Generator-for-Jira

# Install dependencies
$ pip install pandas openpyxl requests

* Configure the configData.json with the necessary information

# Run the app
$ python3 SLA-Report.py
$ python3 Status-Report.py

This software uses the following Python libraries:

• Pandas - For data analysis;
• Openpyxl - For .xlsx manipulation;
• Requests - For API requests.