Enhance Support Stats reporting - change data format

[andyrogers1973]

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

To improve the ability to report Support Request stats we need to change the format that the data is collected in. This will improve the ability of the data tools to read and interpret the data and allow for better reporting options, which will include access to historical data (i.e. requests from 2023) to allow month by month comparisons etc.

To achieve this:

• create a test sheet to record data in long format instead of wide (record each request on a single row instead of a count by date)
• add a dropdown list to be able to select the request type
• test this converts to a .csv file without formatting issues

Once tested:

• convert existing data for 2024 into long format
• convert existing data for 2023 into long format
• combine 2024/2023 data into 1 sheet

Considered done when:

• data is being recorded in the long format
• data can be exported into .csv format without issue

[andyrogers1973]

Existing data for the period 23/10/2023 to 28/03/2024 has been converted to long data via python/pandas script.

A new Google Sheet for testing has been setup containing the long data version of all the support requests for the time period above - data-all

[andyrogers1973]

Test sheet now has a 'new-data' tab that uses a dropdown list to select the request type, and a 'date' chooser to select the required date (must be before today). Up to 20 entries can be made on this tab (based upon the average number of daily Support Requests of 15).

Once data is added, a button can be clicked to run a script that will copy these new entries to the first empty row of the 'test_data' tab - simulating how we can update the existing 'data-all' sheet by adding yesterdays support requests. The script will then clear the source data ready for new entries.