Difficult to give a good answer without seeing your twbx workbook with the data -
I do something similar with a client and I count the number of questions with answers then for each respondent I take the record with the max number ow questions answered (they are interested in getting all respondents even if the only answer a single question ) you could just put in a clause that the need to meet a min number or questions answered then take the max by respondent in case they have 2 records greater than your threshold
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Hi Mi Ma,
Would you mind adding a sample data or twbx file ?
Now how to solve it ::
- There must be a key attribute to differentiate among the survey i.e. participants can be differentiated .
- Cant differentiate this on basis of name as two participants may have same name and last name.
If yes then yes we can deal with it .If not you have to create a field for this .
So your data may look like this .
Participant ID | Name | Q1 | Q2 | Q3 | Q4 | Q5 and so on
Now for any data which is not available use NA or it will be a NULL value .
You have to count this NULL value or NA using COUNT .
Please mark it right and helpful if this serves your purpose ,so that others can also get benefited .