apoc.stats.degrees

This procedure is not considered safe to run from multiple threads. It is therefore not supported by the parallel runtime. For more information, see the Cypher Manual → Parallel runtime.

Details
Syntax	`apoc.stats.degrees([ relTypes ]) :: (type, direction, total, p50, p75, p90, p95, p99, p999, max, min, mean)`
Description	Returns the percentile groupings of the degrees on the `NODE` values connected by the given `RELATIONSHIP` types.
Input arguments	Name	Type	Description
Input arguments	`relTypes`	`STRING`	The relationship types to calculate the percentile grouping over. If this is empty or omitted, all relationships are used. The default is: ``.
Return arguments	Name	Type	Description
	`type`	`STRING`	The type of the relationship.
	`direction`	`STRING`	The direction of the relationship.
	`total`	`INTEGER`	The total observed relationships.
	`p50`	`INTEGER`	The 50th percentile grouping.
	`p75`	`INTEGER`	The 75th percentile grouping.
	`p90`	`INTEGER`	The 90th percentile grouping.
	`p95`	`INTEGER`	The 95th percentile grouping.
	`p99`	`INTEGER`	The 99th percentile grouping.
	`p999`	`INTEGER`	The 99.9th percentile grouping.
	`max`	`INTEGER`	The max value.
	`min`	`INTEGER`	The min value.
	`mean`	`FLOAT`	The mean value.

Usage Examples

The examples in this section are based on the following sample graph:

CREATE (TheMatrix:Movie {title:'The Matrix', released:1999, tagline:'Welcome to the Real World'})
CREATE (Keanu:Person {name:'Keanu Reeves', born:1964})
CREATE (Carrie:Person {name:'Carrie-Anne Moss', born:1967})
CREATE (Laurence:Person {name:'Laurence Fishburne', born:1961})
CREATE (Hugo:Person {name:'Hugo Weaving', born:1960})
CREATE (LillyW:Person {name:'Lilly Wachowski', born:1967})
CREATE (LanaW:Person {name:'Lana Wachowski', born:1965})
CREATE (JoelS:Person {name:'Joel Silver', born:1952})
CREATE
(Keanu)-[:ACTED_IN {roles:['Neo']}]->(TheMatrix),
(Carrie)-[:ACTED_IN {roles:['Trinity']}]->(TheMatrix),
(Laurence)-[:ACTED_IN {roles:['Morpheus']}]->(TheMatrix),
(Hugo)-[:ACTED_IN {roles:['Agent Smith']}]->(TheMatrix),
(LillyW)-[:DIRECTED]->(TheMatrix),
(LanaW)-[:DIRECTED]->(TheMatrix),
(JoelS)-[:PRODUCED]->(TheMatrix);

CALL apoc.stats.degrees();

Results
type	direction	total	p50	p75	p90	p95	p99	p999	max	min	mean
NULL	"BOTH"	7	1	1	1	7	7	7	7	1	1.75

CALL apoc.stats.degrees("ACTED_IN");

Results
type	direction	total	p50	p75	p90	p95	p99	p999	max	min	mean
"ACTED_IN"	"BOTH"	4	1	1	1	4	4	4	4	0	1.0