API & data
DVF: why several rows can describe one sale
Counting rows and counting transactions are different operations. That distinction changes your charts.
Inspect the structure
A transaction may cover several real estate components. Before totaling export amounts, inspect identifiers and the detail represented by each row. If a transaction value appears on several components, adding every row may count the same amount more than once.
Build a small control case
Take a fictional apartment and outbuilding sold together. Write down the expected result first: one overall sale with several descriptive components. Compare your grouping against that expectation. A manual check on a small sample is more informative than a large total with an unexplained calculation method.
Explain the denominator
In a summary, state whether you count rows, premises, or distinct transactions. Keep the definition consistent across neighborhoods and periods. Otherwise, a structural difference may look like a market change.
Checklist
- Identify what rows represent
- Test a simple grouping
- Name what you count