I am trying to fetch date-wise running total of member counts.The relationships in data base are like this
(city:City) //has name property
-[:Has_Club]->
(c:Club) // has name property
-[:Has_Member]->
(p:Person{
name:"XYZ", //string
joinDate...
My neo4j relationships look something like....
(city:City {name:'city_name'})
-[:Has_Club]->
(c:Club {name:"ABC"})
-[:Has_Member]->
(p:Person{
name:"XYZ",
joinDate:'date_ in_datetime_format'
})
So for one particular city, I want to produce a...
i want to get the running total, this query you have suggested only produces member count of a particular day. in your suggested query, is there any way I can collect the memberCount values in a list, so that I can use that list with reduce function ...
no the columns i want are 'day', 'clubA' , 'clubB' , clubC and more club columns if they exist
/ day clubA clubB clubC
1. date1 2 3 3
2. date2 3 5 3
3. date3 4 7 6 ...
