2x2-matrix classification principle-card Matches source row grain Different grain Same grain Safe to sum Do not sum Sum safely Use directly Same grain and additive Example: monthly payroll amount in an employee-month table. Pivot sums are usually safe. tl Separate table Different grain but additive Example: department headcount repeated on employee rows. Store it in department-month grain before aggregating. tr Calculate output
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in