apoc.agg

apoc.agg.first

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

Function

apoc.agg.graph

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

Function

apoc.agg.last

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

Function

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.agg.median

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

Function

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.agg.nth

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

Function

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.agg.product

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

Function

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