Aggregation Verbs

Accumulator operations and array aggregation functions (sum, count, min, max, avg).

Verb	Syntax	Description	Try It
accumulate	`%accumulate name value`	Add value to accumulator	Try
sum	`%sum @array.field`	Sum of field values	Try
count	`%count @array`	Count items	Try
min	`%min @array.field`	Minimum value	Try
max	`%max @array.field`	Maximum value	Try
avg	`%avg @array.field`	Average value	Try
first	`%first @array`	First element	Try
last	`%last @array`	Last element	Try
countIf	`%countIf @array "field" "op" value`	Count items matching a condition	Try
sumIf	`%sumIf @array "field" "op" value ["sumField"]`	Sum a field over matching items	Try
avgIf	`%avgIf @array "field" "op" value ["avgField"]`	Average a field over matching items	Try

Examples

Aggregation examples

; Array aggregation
total_premium = %sum @vehicles.premium
vehicle_count = %count @vehicles
avg_premium = %avg @vehicles.premium
oldest_year = %min @vehicles.year
primary_vin = %first @vehicles.vin