Define Required Dashboard Metrics (Phase 1 Design.1)

Phase: 1 Design
Labels: quartz, phase-1, design, grafana
Blocks: Phase 1 Design: Database Schema, Phase 1 Design: Data Extraction Spec
(both must be verified against the agreed metric list)

Define which metrics the Grafana dashboards need, then trace each metric back to
the TheRock data that must be extracted and stored — ensuring the data extraction
spec and database schema cover everything end to end.

Tasks

• Enumerate the metrics required from TheRock CI data for TheRock HUD dashboards
• Enumerate the metrics required from TheRock CI data for Grafana dashboards,
• For each metric, identify which TheRock data points it depends on and verify
  those are captured in the Data Extraction Spec — if not, update the spec
• Verify the Database Schema covers all required columns and granularity for
  each metric — if not, update the schema design
• Document the agreed metric list as a reference for Phase 1 Design: Database
  Schema and Phase 2 C1 (materialized views)

Notes

• This issue must be resolved before finalizing either the Data Extraction Spec or
  the Database Schema.
• Materialized views for these metrics are designed later in Phase 2 C1.