Granularity
The level of detail that one row represents. A table with one row per order line is finer grained than a table with one row per order.
Combining tables of different granularity is a classic way to double count. Join orders to order lines and each order total repeats once for every line.
Where it comes up
- Totals and notes rows inside the dataRows that are not records, such as subtotals, grand totals, and footnotes, sit among the rows that are.
See also
- RecordOne row of a table: the set of values that together describe a single thing, such as one customer or one transaction.
- JoinCombining two tables by matching rows that share a value, such as attaching customer names to orders through a customer ID.
- Tidy dataA table layout in which each row is one observation, each column is one variable, and each cell holds one value.