Data Freshness Calculator
Measure how old your data is when it is used, against your own target.
In short
Formula: Lag = Time of use - Time the last successful load finished; inside target when Lag <= Target
What this calculator does
Data currency as described in data-management practice: the elapsed time between the most recent successful load and the moment of use. A failed or partial load does not count as a load. The target is compared, never supplied.
Use it to turn Last successful load finished, Time the data is being used, Freshness target into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this professional & industry calculation.
Inputs and what they mean
- Last successful load finished
- — datetime-local value.
- Time the data is being used
- — datetime-local value.
- Freshness target
- — The maximum lag your team agreed. Nothing is assumed about what it should be..
How to use it
- Enter your own figures — the calculator never fills in a rate, price or benchmark for you.
- Press Calculate to see the result.
- Read the formula, variables, assumptions and source below the result before you rely on it.
Formula
Lag = Time of use - Time the last successful load finished; inside target when Lag <= Target.
Inputs used: Last successful load finished, Time the data is being used, Freshness target.
Edge handling: Last successful load finished is required.; Last successful load finished must use a valid calendar date.; Time the data is being used is required.; Time the data is being used must use a valid calendar date.; Freshness target is required..
Worked example
Loaded at 06:00, used at 07:20, against a 60-minute target
- Start with Last successful load finished: 2026-09-17T06:00, Time the data is being used: 2026-09-17T07:20, Freshness target: 60.
- Apply the method: Lag = Time of use - Time the last successful load finished; inside target when Lag <= Target.
- Both times and the target are yours; no freshness standard is assumed.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Inputs outside the supported range are rejected rather than forced into a result.
- The result depends on the values you enter for this data freshness calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Reference: DAMA International — DAMA-DMBOK — Data Management Body of Knowledge
Last reviewed:
Common questions
Where does this formula come from?
DAMA-DMBOK data storage, integration and data-quality practice: volume growth is projected from measured history under a stated model; compression ratio is uncompressed size divided by stored size; throughput is volume processed divided by elapsed time; data currency (freshness) is the age of the data at the time it is used, measured against a stated requirement. See the source link on this page.
What kind of calculation is this?
The age of the data when it is used, compared with a target the user states. Check the formula, example, and limitations on this page before using the result for a real professional & industry decision.
What are its limits?
Lag measures the age of the data, not whether the data is correct or complete. A single reading says nothing about how often the target is met; that needs the same measurement repeated over a period.
How do I use the Data Freshness Calculator?
Enter the required values for Last successful load finished, Time the data is being used, Freshness target. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Data Freshness Calculator use?
Lag = Time of use - Time the last successful load finished; inside target when Lag <= Target The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone. Check the formula, example, and limitations on this page before using the result for a real professional & industry decision.
Can the Data Freshness Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Formula, source and verification
The age of the data when it is used, compared with a target the user states.
The question it answers: How many records a second does this run manage, and how old is the data when someone reads it?
The formula
Lag = Time of use - Time the last successful load finished; inside target when Lag <= Target
- tu — Time of use
- (datetime). When the data is being read.
- tl — Last successful load finished
- (datetime). End of the most recent load that succeeded.
- T — Freshness target
- (min). The maximum lag the team has agreed. Supplied by the user only.
Units: Two date-times in; a lag in minutes and hours out, with a comparison against the stated target.
What kind of calculation this is
Deterministic formula. The same inputs always give the same answer. The maths is fixed and does not depend on judgement.
Method
Data currency as described in data-management practice: the elapsed time between the most recent successful load and the moment of use. A failed or partial load does not count as a load. The target is compared, never supplied.
Assumptions built into the result
- Mathematical: Both times are on the same clock and in the same time zone.
- Mathematical: The last load named is one that completed successfully.
- Industry: The target is the user's own agreement, not a standard.
Figures this calculator will never guess for you
- No target, benchmark, industry average or typical figure is supplied for any value.
- A definition is never presented as a goal: the freshness formula is not a freshness target, and the growth formula is not a forecast of what growth should be.
- No freshness target, service level or acceptable lag is supplied or implied.
Limitations
- Lag measures the age of the data, not whether the data is correct or complete.
- A single reading says nothing about how often the target is met; that needs the same measurement repeated over a period.
Source and version
- Standard or reference
- DAMA-DMBOK — Data Management Body of Knowledge — DAMA International (DAMA-DMBOK data storage, integration and data-quality practice: volume growth is projected from measured history under a stated model; compression ratio is uncompressed size divided by stored size; throughput is volume processed divided by elapsed time; data currency (freshness) is the age of the data at the time it is used, measured against a stated requirement.)
- Published source
- DAMA International — DMBOK
- Formula version
- Version 1
- Verification
- Reviewed against the cited source on
- How much weight the source carries
- Standards or government
- Applies to
- Currency
- The result is a ratio or index, so it does not depend on currency.
Related tools
Work out the hourly rate to charge a client so that target margin is met after overhead and non-billable time.
Find the true hourly cost of an employee once benefits, payroll cost and overhead are included.
Size a software application from its data and transaction functions before estimating effort or cost.
Estimate development effort, schedule and average team size for a software project of a known size.
Express cloud spend as a cost per customer, per transaction or per other business unit.
Set the rate used to apply manufacturing overhead to jobs for the coming period.