Skip to main content

Aggregation

Aggregate data using Cypher's aggregation functions.

Setup​

import { InMemoryGraphFactory } from 'grafio';
import { CypherEngine } from 'grafio/cypher';

const factory = new InMemoryGraphFactory();
const graph = factory.forGraph('default');
const engine = new CypherEngine(graph);

Aggregation Functions​

FunctionDescription
COUNT(*)Count all rows
COUNT(expr)Count non-null values
COUNT(DISTINCT expr)Count unique values
AVG(expr)Average of numeric values
SUM(expr)Sum of numeric values
MIN(expr)Minimum value
MAX(expr)Maximum value
COLLECT(expr)Collect values into array

Basic Aggregation​

Count All​

MATCH (p:Person) 
RETURN COUNT(p) AS total

Average​

MATCH (p:Person) 
RETURN AVG(p.age) AS avgAge

Sum​

MATCH (p:Person) 
RETURN SUM(p.age) AS totalAge

Min/Max​

MATCH (p:Person) 
RETURN MIN(p.age) AS youngest, MAX(p.age) AS oldest

With Type Filter​

MATCH (p:Product) 
RETURN COUNT(p) AS count, AVG(p.price) AS avgPrice

With GROUP BY​

MATCH (p:Person) 
RETURN p.city, COUNT(p) AS count, AVG(p.age) AS avgAge
ORDER BY count DESC

Using DISTINCT​

MATCH (p:Person)-[:KNOWS]->(f:Person) 
RETURN COUNT(DISTINCT f.city) AS uniqueCities

Complex Example​

MATCH (p:Person) 
RETURN p.city AS city,
       COUNT(p) AS count,
       AVG(p.age) AS avgAge,
       MIN(p.age) AS youngest,
       MAX(p.age) AS oldest
ORDER BY count DESC

Next Steps​