I have a graph with events on a timeline and participants in events. I want to do some queries for statistics about how regularly participants attend, given that the events are irregularly spaced along the timeline.
(:Event)-[:OCCURS]->(:Week) along with a time-tree of weeks (:Week)-[:NEXT_WEEK]-(:Week).
How can I isolate the weeks when an event occurs so that I can count the weeks between events?
For example, if I query
MATCH p=( (:Event)-[:OCCURS]->(w:Week) ) WITH p MATCH (w)-[nw:NEXT_WEEK*]->(ww:Week)-[:OCCURS]-(:Event) RETURN length(nw) ORDER BY w the browser spins interminably. ...actually, I don't even get a response when I prepend it with