Parameters, Value
Average function calculates the average value of a column of data. It only keeps the data column as well as its homologous columns after aggregation, and it abandons other columns.
Syntax:
- Format: avg(
<column>) - Parameters: see table below
- Value: ATTR ( number )
| Name | Category | Specification | Description |
|---|---|---|---|
<column> |
NODE，EDGE，PATH，ATTR，ARRAY，TABLE | / | The column to be calculated |
The value of <column> with different categories in every row:
| Type | Value |
|---|---|
| NODE | Node's UUID in the row |
| EDGE | Edge's UUID in the row |
| PATH | ROW INDEX（starts from 0）in the row |
| ATTR | ATTR's value in the row |
| ARRAY | The value of the 1st element in the array of the row |
| TABLE | ROW INDEX（starts from 0）in the row |
ATTR (Numeric value)
Example: find the outbound 1-step paths from Card CA001, and calculate the average value of the amount of money transferred
n({_id == "CA001"}).re({@transfer} as pay).n({@card})
return avg(pay.amount)