Targets & Thresholds: Red, Amber, Green with IFS
This lesson is part of the course
In this lesson
You measure every KPI's gap to target (with 'lower is better' KPIs), set a Red/Amber/Green status with IFS, count the Reds and colour them.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- KPI Definitions as Formulas: Ratios, Rates and Averages Locked
- Targets & Thresholds: Red, Amber, Green with IFS Locked
- Scoring Key Results 0–1: Linear Progress from Baseline to Target Locked
- Objective Score as a Weighted Average of Key Results Locked
- Cascading Team OKRs to Company Level with SUMPRODUCT Locked
- Leading vs Lagging Indicators: CORREL with a Lag Locked
- Trend & Variance vs Target over the Months Locked
- Metric Quality Checks: Completeness and Outliers Locked