Define evaluation ranges for your key figures here to automatically classify KPI values. Define value ranges with operators (e.g. ≥ 80% = "very good", 60-80% = "good", < 60% = "needs improvement") and assign each range a meaningful color and optionally an icon. This allows you to visually evaluate key figures at a glance - for example, using traffic light colors in dashboards and reports.
Identification
Define the basic data of the rating level here: code and designation (e.g. "VERY_GOOD" and "Very good"), the associated key figure and a detailed description. Determine the sort order for the display and select a color to visually identify this rating level in evaluations.
| Property | Description |
| Code | Enter a unique technical code for this rating level (e.g. "VERY_GOOD", "GOOD", "SATISFACTORY", "POOR"). The code is used for internal system referencing and should be descriptive but short. |
| Color | Select a color for this evaluation level (e.g. "green" for very good, "yellow" for satisfactory, "red" for poor). The color is used in dashboards, reports and traffic light displays for immediate visual recognition. Enter either a color name (e.g. "green") or a hex code (e.g. "#00FF00"). |
| Description | Add a detailed description of this assessment level here. Explain what this assessment means, what measures may be required or what the underlying objective is. This information will help users to interpret the assessment correctly. |
| Key figure | Select the key figure to which this rating level applies. Each key figure can have several rating ranges, which together form a complete rating scale (e.g. "Very good" to "Unsatisfactory"). |
| Designation | Enter the user-friendly designation here that is displayed in reports and dashboards (e.g. "Very good", "Good", "Satisfactory", "Needs improvement"). End users will see this designation in all evaluations. |
| Sorting | Determine the display order of this rating level in lists and drop-down menus here. Lower values are displayed first. Use e.g. 10, 20, 30 to be able to insert new levels later. |
| Internal ID (Data ID) | Internal ID of the data record |
Rating
Define the numerical value range for which this evaluation applies. Combine lower and upper limit values with comparison operators (>, >=, =, <=, <) to define precise conditions. Example: Operator ">=" with value 80 and operator "<" with value 100 means "Values between 80 and 99.99 receive this rating".
| Property | Description |
| Operator (from) | Select the comparison operator for the lower limit of the value range here: ">" (greater than), ">=" (greater than or equal to) or "=" (exactly equal to). Example: ">=" with value 80 means "applies to all values from 80 upwards". Permitted values are restricted by the database constraint to >, >=, =. |
| Value (from) | Enter the lower limit of the value range here. Together with the operator, you define the condition (e.g. operator ">=" and value 80 means "from 80"). Leave the field empty if there is no lower limit (e.g. for "everything below 60"). |
| Operator (to) | Select the comparison operator for the upper limit of the value range here: "<" (less than), "<=" (less than or equal to) or "=" (exactly equal to). Example: "<" with value 100 means "applies to all values up to and including 100". Permitted values are restricted by the database constraint to <, <=, =. |
| Value (to) | Enter the upper limit of the value range here. Together with the operator, you define the condition (e.g. operator "< |
