Following are the supported inbuilt aggregate functions of Siddhi.
sum
| Syntax | <long|double> sum(<int|long|double|float> arg) |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Calculates the sum for all the events. |
|---|
| Parameter | The value that needs to be summed. |
|---|
| Return Type | Returns long if the input parameter type is int or long, and returns double if the input parameter type is float or double. |
|---|
| Examples | sum(20) returns the sum of 20s as a long value for each event arrival and expiry. sum(temp) returns the sum of all temp attributes based on each event arrival and expiry.
|
|---|
avg
| Syntax | <double> avg(<int|long|double|float> arg) |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Calculates the average for all the events. |
|---|
| Parameter | arg: The value that need to be averaged. |
|---|
| Return Type | Returns the calculated average value as a double. |
|---|
| Example | avg(temp) returns the average temp value for all the events based on their arrival and expiry. |
|---|
max
| Syntax | <int|long|double|float> max(<int|long|double|float> arg) |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Returns the maximum value for all the events. |
|---|
| Parameter | arg: The value that needs to be compared to find the maximum value. |
|---|
| Return Type | Returns the maximum value in the same data type as the input. |
|---|
| Example | max(temp) returns the maximum temp value recorded for all the events based on their arrival and expiry. |
|---|
min
| Syntax | <int|long|double|float> min(<int|long|double|float> arg) |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Returns the minimum value for all the events. |
|---|
| Parameter | arg: The value that needs to be compared to find the minimum value. |
|---|
| Return Type | Returns the minimum value in the same type as the input. |
|---|
| Example | min(temp) returns the minimum temp value recorded for all the events based on their arrival and expiry. |
|---|
count
| Syntax | <long> count() |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Returns the count of all the events. |
|---|
| Return Type | Returns the event count as a long. |
|---|
| Example | count() returns the count of all the events. |
|---|
stddev
| Syntax | <double> stddev(<int|long|double|float> arg) |
|---|
| Extension Type | Aggregate Function |
|---|
| Description | Returns the calculated standard deviation for all the events. |
|---|
| Parameter | arg: The value that should be used to calculate the standard deviation. |
|---|
| Return Type | Returns the calculated standard deviation value as a double. |
|---|
| Example | stddev(temp) returns the calculated standard deviation of temp for all the events based on their arrival and expiry. |
|---|