apoc.agg

apoc.agg.first

apoc.agg.first(value) - returns first value

Function

APOC Core

apoc.agg.graph

apoc.agg.graph(path) - returns map of graph {nodes, relationships} of all distinct nodes and relationships

Function

APOC Core

apoc.agg.last

apoc.agg.last(value) - returns last value

Function

APOC Core

apoc.agg.maxItems

apoc.agg.maxItems(item, value, groupLimit: -1) - returns a map {items:[], value:n} where value is the maximum value present, and items are all items with the same value. The number of items can be optionally limited.

Function

APOC Core

apoc.agg.median

apoc.agg.median(number) - returns median for non-null numeric values

Function

APOC Core

apoc.agg.minItems

apoc.agg.minItems(item, value, groupLimit: -1) - returns a map {items:[], value:n} where value is the minimum value present, and items are all items with the same value. The number of items can be optionally limited.

Function

APOC Core

apoc.agg.nth

apoc.agg.nth(value,offset) - returns value of nth row (or -1 for last)

Function

APOC Core

apoc.agg.percentiles

apoc.agg.percentiles(value,[percentiles = 0.5,0.75,0.9,0.95,0.99]) - returns given percentiles for values

Function

APOC Core

apoc.agg.product

apoc.agg.product(number) - returns given product for non-null values

Function

APOC Core

apoc.agg.slice

apoc.agg.slice(value, start, length) - returns subset of non-null values, start is 0 based and length can be -1

Function

APOC Core

apoc.agg.statistics

apoc.agg.statistics(value,[percentiles = 0.5,0.75,0.9,0.95,0.99]) - returns numeric statistics (percentiles, min,minNonZero,max,total,mean,stdev) for values

Function

APOC Core

apoc.agg.position

Returns index of the element that match the given value

Function

APOC Full

apoc.agg.row

Returns index of the element that match the given predicate

Procedure

APOC Full