apoc.schema.properties.distinctCount
Procedure

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.
Prior to the release of APOC 2025.07, this procedure was restricted on on-premise instances. To use it on an older version, it must be unrestricted. For more details, see Installation → Load and unrestrict.

Details
Syntax	`apoc.schema.properties.distinctCount([ label, key ]) :: (label, key, value, count)`
Description	Returns all distinct property values and counts for the given key.
Input arguments	Name	Type	Description
	`label`	`STRING`	The node label to count distinct properties on. The default is: ``.
	`key`	`STRING`	The name of the property to count distinct values of. The default is: ``.
Return arguments	Name	Type	Description
	`label`	`STRING`	The label of the node.
	`key`	`STRING`	The name of the property key.
	`value`	`ANY`	The distinct value.
	`count`	`INTEGER`	The number of occurrences of the value.

Usage Examples

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

CREATE (:Person {name: "Michael"});
CREATE (:Person {name: "Ryan"});

CALL apoc.schema.properties.distinctCount("Person", "name");

Results
label	key	value	count
"Person"	"name"	"Michael"	1
"Person"	"name"	"Ryan"	1