Enhance Support Stats reporting - add new reporting information

[andyrogers1973]

Replaces https://github.com/ministryofjustice/operations-engineering/issues/4209 which has been broken down into smaller tickets.

Currently the Support Requests data sheet has functionality to report weekly/monthly/yearly data. This ticket looks to add the same functionality to the report that is sent to the Slack channel. It will also look at the ability to provide this data as a usable report (i.e in a word document).

Ticket https://github.com/ministryofjustice/operations-engineering/issues/4209 changes the format the data is recorded in to make it easier for data analysis tools to work with, which needs to be completed before this ticket can be started.

• Data that is currently reported:
  • Totals for last week/last month/this year
  • Running totals for this week/this month/year
  • Highest request_type for the week/month/year
  • Top 10 request_type for months/year

To achieve this:

• Speak with team to understand what information they would like to see
• Update the functions in the python script to pull out the data we need
• Update unit tests for the changes added to the script
• Investigate if report data can be extracted as a report, not just a Slack message
• Remove stub data used for demonstrating support stats reporting (not live data, just test)

Considered done when:

• new reporting options are available
• new reporting is set to a schedule agreed with the team
• if data can be extracted as a separate report (not just a Slack message) agree the format and where to store/present this info

[andyrogers1973]

Have been testing reporting the required data via KPI dashboard.

Current status:

• year to date stats are working, needs a tweak to report only the current year - in progress
• current month stats working, needs rework to count each type rather than build the graph showing each request individually
• current week - started, not in a working state
• totals for week/month/year - this info is displayed on the respective plots so not required separately
• last week/month/year - not started, not sure if this info is required

[andyrogers1973]

2 reports are ready to add to the KPI dashboard:

• year to date graph of support requests
• current month support requests

Have removed the 'weekly' stats report as this data can be seen in the monthly report

[andyrogers1973]

Last update will be to remove the existing stub data and code that was setup during a Firebreak sprint to demonstrate reporting of support request data.

[andyrogers1973]

Add fix for an errant character Add fix for an incorrectly named graph - changed it to more clearly reflect what it shows, did not update it in app.py

[andyrogers1973]

Reports are now displaying on the KPI dashboard, closing as considered done