Data Validation Design
Data validation in JustPerform restricts input values within a range by comparing the input to selected Comparer Type. Only those values qualifying the comparer range are allowed. Validation is unique to input metric type.
Validation Configuration
Validation is configured in the Metric Details section for input metrics. The basic input types like Number, Integer, Percentage, Currency have Validation sections, while List has Allowed Values, Data status has Allowed values plus Data Status settings, and Field has a specialized Validation section.
Comparer Types
The available Comparer Type options are:
- No Validation
- Greater than
- Less than
- Between
- Not between
- Equal to
- Not Equal to
- Less than or Equal to
- Greater than or Equal to
Validation type changes according to the metric type. Validation allows users to show custom messages when values violate the validation rule. This helps guide users to correct their entries and maintain data quality.
Validation by Data Type
List Validation
The metric detail in List includes an Allowed Values section that displays all the allowed values and options to create more, delete existing, and change their order of appearance.
Data Status Validation
Data Status validation includes:
Allowed Value - List displays all the allowed values for Data Status. Any one of these could be set as Default status.
Driver - Driver is a mandatory field selection based on which the Teams in data protection rule will be based.
Data Protection Rule - Specific rules can be created for individual data status member and assigned permission.
Rules - The rule follows the format "Status allows edits by Team", where Status is the allowed value and Team is the user group.
Applies to - The rule can be applied to specific metric or an entire functional area.
Restrict Status Change - This option allows creation of Data Status change from one allowed value to another by specified Team.