People Ops Exit Survey: Spot the Denominator Leak
Identify when a join changes the denominator before a grouped metric is calculated.
The denominator shrank before the department rollup. Where is the issue in Nia's attrition report setup? Exited employee population This is the population the metric needs. It should stay intact while survey facts are attached. Survey stream join that drops missing responses Correct. The join is narrowing the employee denominator before grouping, so the later department counts measure only surveyed exits. Department grouping area Grouping by department is appropriate once the row set is right. The leak has already happened before this stage. Final dashboard bars The chart is only showing the result. Fixing labels or colors cannot repair a…
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in