Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ( @sunny_talwar ) (It's been a while btw, hope u're doing well !!)
Well my request is rather simple, to help understand this expression I made but that didn't do as I wanted it to :
Count( distinct {
<ID_QUESTION={'1'},Regroupement_ID={'2'},ID_REPONSE={'5','4','3'}>
*
<ID_QUESTION={'2'},Regroupement_ID={'2'},ID_REPONSE={'1','2','3','4','5','6'}>
} UserID)
What I want to do is :
Count the UserID that are part of Regroupement_ID=2 and responded to Question =1 by responses 3,4 OR 5
and to Question 2 by responses 1,2,3,4,5, OR 6
Isn't my expression supposed to return this?
Because it returns 0 while I'm pretty sure 0 is not the expected outcome.
What am I doing wrong?
Try this
Count(DISTINCT {<UserID = P({<ID_QUESTION = {'1'}, Regroupement_ID = {'2'}, ID_REPONSE = {'5','4','3'}>}) * P({<ID_QUESTION = {'2'}, Regroupement_ID = {'2'}, ID_REPONSE = {'1','2','3','4','5','6'}>})>} UserID)
Same result.. 0.
Don't understand why !
Create a straight table with UserID as dimension and two expressions
1)
Count(DISTINCT {<UserID = P({<ID_QUESTION = {'1'}, Regroupement_ID = {'2'}, ID_REPONSE = {'5','4','3'}>})>} UserID)
2)
Count(DISTINCT {<UserID = P({<ID_QUESTION = {'2'}, Regroupement_ID = {'2'}, ID_REPONSE = {'1','2','3','4','5','6'}>})>} UserID)
Do you see rows where both the expressions are giving 1?