In my graph I have the below node-relationship structure :
Now a Question can be of type multi select i.e. User can select multiple responses as an answer to that question.
So in case I get the below result :
I need to find how many questions have been answered by a responder.
My query :
But this gets both the responses that were selected.
I only need to know if a question was answered or not.
Try this: // find all the questions that were answered..... match (q:Question)-->(r:Response) with q, r //find count of answered questions per each responder..... match (u:Responder)-->(r)--(q) //find total questions.... match (q1:Questions) with count(q1) as TotCnt return u.name as usr, count(q) as cnt, TotCnt