Skip to main content
SQL-BASICS5 MIN READ

People Ops Exit Survey: Spot the Denominator Leak

Identify when a join changes the denominator before a grouped metric is calculated.

People operations conference room with an analyst at a laptop, HR partner reviewing a wall display of abstract department bars, two data streams shown as colored cables into a monitor, modern clean workspace with space for hotspot overlays, no text, words, letters, numerals, logos. The attrition report should start from all exited employees. A survey-response data stream is joined upstream, and the suspicious issue is that employees without survey responses may be dropped before department counts are grouped. The denominator shrank before the department rollup. Where is the issue in Nia's attrition report setup? Exited employee population This is the…

Read the full lesson

Sign up free — one personalized lesson every day, matched to your role and goals.

Already have an account? Sign in

← Back to library