Re‐execute: Charter 28: Explore production summary table with reference to the database to discover accuracy

Charter:

• Explore production summary table with reference to the database to discover accuracy

Testers:

• Mike Walker-Rose

Date:

• 23/08/24

Duration:

• 45 - 90 mins

Scope:

• UI summary table on prod

References:

• UI
• prod database

Test Approach:

• Query the prod forecast database for a specific city and base time
• Query the prod in situ database for a specific city across the different measurement dates for a forecast window of 1
• Manually calculate the average in situ values for each in situ measurement date
• Compare to the forecasts for the window
• compare to the table in the UI

Notes

• target Atlanta (Time Range: 21 Aug 12:00 - 22 Aug 12:00 UTC)
• in situ query { $and: [ { measurement_date: { $gte: ISODate("2024-08-21T10:30:00.000Z"), $lte: ISODate("2024-08-22T13:30:00.000Z") } }, { name: "Atlanta" } ] }
• forecast query { $and: [ { forecast_base_time: ISODate( "2024-08-21T12:00:00.000Z" ) }, { name: "Atlanta" } ] }

Conclusion

• database data correlates to the UI data displayed in the summary table
• issue is fixed where previously ifthe measured AQI and forecasted AQI were both 1 for the entire duration of the time, the UI picked the last entry. It now picks the first