This content has been marked as final.
Show 1 reply
-
1. Re: Help with comparing pre and post survey data in a worksheet
swaroop.gantela Feb 14, 2018 8:06 PM (in response to Julia Harrigan)Julie,
Not sure if this quite got there, but maybe it can give ideas.
Attached in the Forum Thread is a mock dataset.
Would be grateful if you would adjust it to more match yours
Wasn't sure how Users only taking Pre showed up in your table:
if they didn't have any rows for Post questions, or if they had a null response.
Regardless, I think this should help discriminate:
Return the QuestionID if the response if not null [Answered Question]:
IF NOT(ISNULL([Response])) THEN [Question ID] END
Then count those returned Question IDs:
{ FIXED [User ID]:COUNT([Answered Question])}
Then the filter is (in this example should have 10 total questions 5Pre + 5Post):
[Count Questions Answered]=10
-
259847survey.xlsx 8.9 KB
-
259847survey.twbx 29.2 KB
-