Zum Hauptinhalt springen

Classify Metrics by Grain and Additivity

Classify Google Sheets metrics by whether they are additive and whether they match the row grain.

google-sheets-mastery5 min read

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.

← Back to library

Kontakt aufnehmen