Column Calculation

Perform statistical operations—such as sum, average, maximum, minimum, median, standard deviation, and standard error—on values from an origin column across records that reference the current record.

Specs

Label
Value

Version

0.1.0 (updated on 2025-08-07)

Developer

Labii Inc.

Type

Column

Support Configuration

Yes

Support Readonly view

Yes

Support Edit view

No

Support Form view

No

Support Default value

No

Support Import

No

Allow multiple

Yes

Overview

The Labii Column Calculation widget enables powerful real-time data aggregation by allowing users to perform statistical operations—such as sum, average, maximum, minimum, median, standard deviation, and standard error—on values from an origin column across records that reference the current record. This widget is especially useful for automating complex calculations like material consumption, total check-in/check-out counts, yield analysis, and other cumulative metrics. By eliminating the need for manual computation and ensuring up-to-date values, the Column Calculation widget streamlines data tracking and enhances analytical precision across workflows.

The Column Calculation widget eliminates the hassle of manually converting values between different units. By configuring the conversion factor within the widget's settings, it can seamlessly perform automatic unit conversions.

Use case

  • Use this widget to calculate the total checkin volume.

  • Use this widget to calculate the total invoice amount.

  • Use this widget to calculate the yield.

Configuration

To configure the widget, specify the data to be calculated and the desired calculation method.

  • Columns of current table

    • Column (Unit) - Choose the column for unit. If this column is left blank, no unit conversion will be performed.

  • Origin table settings

    • Table (Origin) - Select a table that stores the original data.

    • Column (Source) of the Origin table - Select the column in the origin table that is associated with the current record.

    • Column (Value) of the Origin table - Select the column in the origin table that is associated with the current record.

    • Column (Unit) of the Origin table - Choose the column in the origin table that records the unit of the value. If this column is left blank, no unit conversion will be performed.

    • Query - Further refine the displayed records by adding supplementary query criteria.

  • Calculation settings

    • Data aggregation - Select how to aggregate the data for the value. Options include sum, average, max, median, min, standard deviation, and standard error.

    • Conversions - Specify the conversion factors for every unit utilized, ensuring inclusion of all units within the quantity unit. If a unit is not provided, a factor of 1 will be utilized.

    • Stop condition - The formula will stop calculation when the condition is met. It must return a true or false value. This field does not support other column data, you can only use the variable data to reference the current record data.

    • Should auto update when readonly - If checked, this widget will perform a live calculation when readonly.

Example

Below is the widget configuration for performing calculations using data from the consumption table.

{
    "current_unit": {
        "sid": "xxx",
        "name": "unit"
    },
    "origin_table": {
        "sid": "xxx",
        "name": "checkin"
    },
    "stop_condition": "data !== \"\"",
    "data_aggregation": "se",
    "origin_column_unit": {
        "sid": "xxx",
        "name": "unit"
    },
    "origin_column_value": {
        "sid": "xxx",
        "name": "quantity"
    },
    "origin_column_source": {
        "sid": "xxx",
        "name": "stock"
    },
    "should_auto_update_when_readonly": false
    "conversions": [
        {
            "unit": "µL",
            "factor": 1
        },
        {
            "unit": "mL",
            "factor": 1000
        },
        {
            "unit": "L",
            "factor": 1000000
        },
        {
            "unit": "µg",
            "factor": 1
        },
        {
            "unit": "mg",
            "factor": 1000
        },
        {
            "unit": "g",
            "factor": 1000000
        },
        {
            "unit": "kg",
            "factor": 1000000000
        },
        {
            "unit": "Each (EA)",
            "factor": 1
        },
        {
            "unit": "Dozen (DZ)",
            "factor": 1
        },
        {
            "unit": "Gross (GR or GRO)",
            "factor": 1
        },
        {
            "unit": "Pair (PR)",
            "factor": 1
        },
        {
            "unit": "Case (CS or CA)",
            "factor": 1
        },
        {
            "unit": "Pack (PK)",
            "factor": 1
        },
        {
            "unit": "Bundle (BDL)",
            "factor": 1
        },
        {
            "unit": "Carton (CTN)",
            "factor": 1
        },
        {
            "unit": "Set (SET)",
            "factor": 1
        },
        {
            "unit": "Roll (RL)",
            "factor": 1
        }
    ]
}

Views

See the interface of the widget in the following views.

Readonly view

Readonly view display the values of the column.

In the readonly view, a warning message will be shown when the remaining volume is equal to or less than the specified threshold.

Edit view

The Edit view is the interface that allows you to modify the value.

Edit view is not supported for this widget.

Form view

The Form view is the field integrated into the add form for collecting values when creating a new record.

Form view is not supported for this widget.

Data

Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.

Data format

Numeric values.

Default value

The Default Value field within the column allows you to specify the default value when a record is created.

Default value is not supported for this widget.

Import value

The Import Value is the value you need to include in your Excel table for it to be imported into Labii.

Import value is not supported for this widget.

Last updated