POU: Unit conversion and IF null conditions
A user can now add configuration to their column inputs at the point of use (POU) within the calculation.
These POUs include:
Unit Conversion
Default Value If Null
Unit Conversion
Unit conversion is the process of converting a quantity expressed in one unit of measurement to another unit of measurement. It involves multiplying the original value by a conversion factor that relates the two units. The goal of unit conversion is to express a quantity in a more useful or convenient unit.
The options for the units a variable may be converted to are determined by the unit of the source column the variable is bound to. For example, if the variable "site_Temp_1" is bound to column "Temp" which is in degrees Celsius, the dropdown in the unit conversion droplet will contain all the units that degrees Celsius can be converted to.
Therefore if the source column has no unit, the variable cannot be converted. This is indicated by disabling the ‘convert to’ config option and showing an explanatory tooltip.
Default Value If Null
Applying a default value to an input of a calculation is the process of applying a value that the input can “default” to when no data is available for the selected datasource. It involves deciding upon the value to default to when adding the input to the calculation.
The appropriate default value to apply will depend on the Kind of the source column, for example, if the source column contains numeric data, the default value must be numeric, etc. The input field in the ‘if null use’ config differs depending on the Kind of the source column
"Condition" is bound to the String column "Condition" so takes a string as the default value.
"Pump_1" is bound to the Numeric column "Pump 1" so takes a number as the default value.
"Sunrise" is bound to the boolean column "Sunrsie" so takes either True or False as a default value.