Neo4j: Aggregation Function Cheat Sheet

Count()

COUNT(expression) 

Max()

MAX(expression) 

An expression returning a set containing any combination of property types and lists thereof.

Min()

MIN(expression) 

An expression returning a set containing any combination of property types and lists thereof.

Sum()

SUM(expression)

An expression returning a set of numeric values or Durations

Avg()

AVG(expression)

An expression returning a set of numeric values or Durations

Collect()

COLLECT(expression)

An expression returning a set of values.

percentileCont()

percentileCont(expression, percentile)

An expression returning a numeric expression.

A percentile returning a numeric value between 0.0 and 1.0

percentileDisc()

percentileDisc(expression, percentile)

An expression returning a numeric expression.

A percentile returning a numeric value between 0.0 and 1.0

stDev()

stDev(expression)

An expression returning a numeric expression.

stDevP()

stDevP(expression)

An expression returning a numeric expression.

Leave a Reply

Your email address will not be published. Required fields are marked *