How do I explain the difference between an opening row count and a closing snapshot?
Added and removed records use the same unique row definition. Updates to existing rows do not change the expected count.
Open Snapshot Drift BridgeTry the worked example
These are the example inputs from Snapshot Drift Bridge. Replace them in the tool to run your own case.
| Table | Open rows | Added | Removed | Observed close |
|---|---|---|---|---|
| Cases | 120 | 17 | 8 | 131 |
| Teams | 12 | 0 | 1 | 11 |
Example result
2 unexplained net rows
Who uses this?
Dataset owner. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Explain the difference between an opening row count and a closing snapshot. The creator describes separating work by customer and using a checked delivery procedure. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video