LessThanColumn / Boolean Layer
Create boolean mask columns by comparing if values in one column are strictly less than corresponding values in another column. Similar to pandas df['A'] < df['B'] or R's element-wise comparison.
Common applications:
- Budget underrun detection
- Resource utilization monitoring
- Performance gap analysis
- Capacity planning
- Risk threshold monitoring
Example:
| Index | Usage | Limit | Less Than |
|---|---|---|---|
| 0 | 80 | 100 | true |
| 1 | 75 | 75 | false |
| 2 | null | 90 | null |
| 3 | 120 | 100 | false |
| 4 | 60 | null | null |
Compare
[, ...]List of less-than comparisons to perform. Each creates a new boolean column. Common scenarios:
- Resource monitoring
- Budget tracking
- Capacity analysis
- Threshold compliance
At least one comparison must be specified.
SelectLeft
columnThe column to compare (left side). Must contain ordered values (numeric, datetime, etc.). Null values result in null in the output mask. Common uses:
- Current usage
- Actual expenditure
- Measured values
Forms the left side of the comparison operation.
SelectRight
columnThe column to compare against (right side). Must be comparable with SelectLeft. Null values result in null in the output mask. Common uses:
- Maximum limits
- Budget allocations
- Threshold values
Forms the right side of the comparison operation.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.