You notice a sudden, significant drop in a key metric—what is your step-by-step process for investigating the root cause?
Using the provided tables, identify metric and segment combinations whose latest three-day average is at least 15% below the preceding three-day average. Ignore observations with a NULL metric value.
metric_name, segment, previous_avg, current_avg, and percent_change.percent_change ascending, then metric_name and segment ascending.| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique metric identifier |
| metric_name | VARCHAR(100) | Display name of the metric |
| Column | Type | Description |
|---|---|---|
| observation_idPK | INT | Unique observation identifier |
| metric_id | INT | Metric associated with the observation |
| metric_date | DATE | Date of the observation |
| segment | VARCHAR(50) | Business segment for the observation |
| metric_value | NUMERIC(12,2) | Observed metric value |