Recent Data Validation

The Recent Data Validation typically refers to the process or action of verifying the timeliness or current relevance of information, actions, or updates.

Rule configuration

The success of rule configuration depends on your ability to define a relevant time frame during which the data remains significant. It relies on establishing specific conditions (unit) for evaluating metrics over that period. By setting time parameters such as days, weeks, months, or years, you ensure that only the most recent and relevant information is considered.

Recency period The recency period refers to a specific time frame during which information, actions, or events are considered relevant, valid, or significant.

Unit The unit establishes the condition that must be satisfied for a given metric, count, or time frame in relation to the recency period.

Days

Weeks

Months

Years

Success criteria

The success criteria are evaluated based on whether the data falls within the specified recency period and meets the conditions defined by the unit.

• The success condition depends on how the recency period and unit are configured.
• The success condition is met if this count satisfies the given operator and value.
• For example, if the Recency check is set to 30 days, only data or actions that occurred within the past 30 days are considered valid for evaluation.

Configuration fields

• Operator options

  Greater than

  Less than

  Equal to

  Between (requires specifying a start and end range)

• Operator defines the comparison operation. You can choose from Greater Than, Less Than, Equal To, or Between.

• Value is the threshold used for success criteria. This is required for the Greater than, Less than, and Equal to operators.

• Value range is required only when the Between operator is selected. You need to specify the start and end range.

• Threshold type indicates whether the Value or Value Range is to be considered as a percentage or an absolute count.

• Allow null values determines whether null values are permitted.

• Check for match determines whether data values align with predefined standards, formats, or reference values to ensure accuracy, consistency, and integrity.

Sample Input

ID	Date	Due Date
1	2025-02-06	2025-02-08
2	2024-10-09	2024-12-08
3	2024-11-14	2025-01-10
4	2024-09-03	2024-12-15
5	2025-01-23	2025-01-29
6	2025-01-01	2025-01-25
7	2024-01-10	2024-01-30

Sample rule configuration

• Recency period is 30
• Unit is Days

Sample success criteria configuration

• Operator Greater than
• Value 3
• Threshold type Absolute Count
• Allow null values False
• Check for match False

Sample Output

Column Name	Rule Name	Success Count	Failure Count	Within Threshold	Null Count
Date	Ship Date Recency	2	5	No	0
Due Date	Ship Date Recency	4	3	Yes	0