Expression Types

Summary

  • There are 5 types of Expressions available in Adaptable:
    • Standard - When AdapTable needs to derive a scalar or boolean value from a single row
    • Aggregated - When AdapTable needs to derive a scalar or boolean value from a set of rows
    • Observable - A Reactive Expression used to watch data changes over time
    • Cumulative - Performs Cumulative Aggregations
    • Quantile - Creates 'buckets' of values

There are 5 different types of Expressions provided by AdapTableQL.

Each are available in different Modules as follows:

TypeReturnsModules
StandardSingle value of any typeAlerts (Boolean)
Calculated Column (Any)
Export (Boolean)
Flashing Cell (Boolean)
Format Column (Boolean)
Grid Filter (Boolean)
Plus Minus (Boolean)
ObservableDetails of Row or Grid ChangesAlerts
AggregationSingle value (calculated across aggregated cells)Alerts (Boolean)
Calculated Column (Any)
CumulativeValue from a Cumulative CalculationCalculated Column
Quantile'Buckets' of valuesCalculated Column