Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello All,
I want to count the number of patients who responded to all the 3 questions : question 1 , 2 , 3.
But this expression is not working.
It does not give the number of patients how reponded the 3 questions , but rather the number of patients who answered one of the 3 questions.
=count({ <[question]={'question1'}, [question]={'question2'}, [question]={'question3}, [responded]= {'Yes'} >}distinct [KEY - Patient])
Many thanks in advance
Thank you vm
I have another question please, how can I set up this solution in the script part, to make a filter which where I can have all the possible combinations:
The respondents just to question 1 and 2 , or 2 and 3 , or 1 and 3 ....
Thank you in advence