fix: monthly release info transformation query
Fix the transformation query.
The original query doesn't work as intended for the status panel, because max_over_time(delivery_release_monthly_status[30d]) makes all the metrics have the same time, so it becomes impossible to sort like we originally had.
This solves that by leaving the query for status panel as delivery_release_monthly_status, then displays the latest metric that was pushed. When there isn't a metric in the last 7 days (this happens between the finalize stage of the last release and the announcement stage of the active release), it defaults to open status. The other panels (version and date) should still display the active version that was created as part of the "open" status metric at the finalize stage of the last version.
Here's an example of the releases' timeline and what will display on the dashboard
Finalized 16.9
"Open" status metric for 16.10 pushed: delivery_release_monthly_status{version: 16.10, release_date: 2024-03-21} 1
Dashboard: 16.10, 2024-03-21, Open (fetched from the metric)
8 days later
No new delivery_release_monthly_status metric has been created in the past 7 days.
Dashboard: 16.10, 2024-03-21, Open (default)
Announced commit sha for 16.10
"Announced" status metric for 16.10 pushed: delivery_release_monthly_status{version: 16.10, release_date: 2024-03-21} 2
Dashboard: 16.10, 2024-03-21, Announced (fetched from the metric)
Tagged RC for 16.10
"Tagged_RC" status metric for 16.10 pushed: delivery_release_monthly_status{version: 16.10, release_date: 2024-03-21} 3
Dashboard: 16.10, 2024-03-21, Tagged RC (fetched from the metric)
Temporary snapshot: https://dashboards.gitlab.net/dashboard/snapshot/YKhB3NJmUw6yDZ0R7VfCg1g9oX4gzoUv
Temporary snapshot, showcasing default case: https://dashboards.gitlab.net/dashboard/snapshot/AHexyfTFAl89F5u7aJsOhBiayfv0pkCM?orgId=1
$ ./test-dashboard.sh delivery/release_info.dashboard.jsonnet
Installed https://dashboards.gitlab.net/dashboard/snapshot/YKhB3NJmUw6yDZ0R7VfCg1g9oX4gzoUv - delivery: Release Information