neo4j/community — Issue #74: Cypher: Support percentile aggregate function
Author: systay
Created: 2011-10-25 22:53:07+00:00
State: open

A feature that would be nice to add to the Cypher language features AVG,
SUM, etc. would be the ability to use a percentile function.

In Oracle: percentile_cont and percentile_disc

http://en.wikipedia.org/wiki/Percentile

A use case could be to ask for certain percentile (e.g. 90) for a 'time
elapsed' property on a bunch of selected 'helpdesk call' nodes with status
'closed'. The result is the time in which 90% of the closed 'helpdesk call'
nodes were solved. 10% of the selected nodes have a 'time elapsed' larger
than the result.

You might know a median, which is actually percentile 50.