Monotonic Sequence

A Monotonic sequence is a sequence of numbers that is either entirely non-increasing or non-decreasing. To check if a sequence is monotonic, you verify whether the sequence is consistently increasing or decreasing throughout, without any changes in direction.

Rule configurations

Rule configuration for monotonic sequence check refers to the set of conditions or rules that are applied to determine if a sequence is monotonic.

Order type Order type in a monotonic sequence check specifies the direction of the sequence,if its either

Ascending

Descending

Strict A strict monotonic sequence check, the sequence must either be strictly increasing (each element is greater than the previous one) or strictly decreasing (each element is less than the previous one), without any equality between consecutive elements.

Success criteria

The success criteria for a monotonic sequence is met when the sequence is consistently either non-increasing or non-decreasing (in the case of non-strict), or strictly increasing or decreasing (in the case of strict), without any reversal in direction.

• The success condition depends on how the Order Type is configured.
• For example a monotonic sequence is 1, 2, 3, 4, which is strictly increasing, while 5, 4, 3, 2 is strictly decreasing.

Configuration fields

• Operator options

  Greater than

  Less than

  Equal to

  Between (requires specifying a start and end range)

• Operator Defines the comparison operation (Greater Than, Less Than, Equal To, or Between).

• Value The threshold value used for success criteria. Required for Greater than, Less than, and Equal to operators.

• Value range Required only when the Between operator is selected, specifying the start and end range.

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

• Allow null values Determines if null values are permitted.

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

Sample Input

ID	Customer	Number
1	Aubrey	83457
2	Fallon	23455
3	FranklynFryer	46573
4	Kathleen	96784
5	JudieGreen

Sample rule configuration

• Order type
• Strict True

Sample success criteria configuration

• Operator Less than
• Value 50%
• Threshold Type Absolute Count
• Allow Null Values False

Sample Output

Column Name	Rule Name	Success Count	Failure Count	Within Threshold	Null Count
Customer	Monotonic Sequence Check	4	1	No	0
Country	Monotonic Sequence Check	2	3	Yes	1