Data and reporting
How do I trace where a number in a report came from?
Keep data lineage from the report metric back through its calculation and transformation to the source fields. Document the formula and make it possible to inspect the underlying records when a number is questioned.
What to check
- Which source fields feed the metric?
- What transformations or calculations are applied?
- Can users inspect supporting records?