apoc.agg

Qualified Name Type Release

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

Function

APOC Core

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

Function

APOC Core

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

Function

APOC Core

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(number) - returns median for non-null numeric values

Function

APOC Core

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(value,offset) - returns value of nth row (or -1 for last)

Function

APOC Core

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(number) - returns given product for non-null values

Function

APOC Core

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(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

Returns index of the element that match the given value

Function

APOC Full

Returns index of the element that match the given predicate

Procedure

APOC Full