Count specific column from matrix and exclude specific row | XM Community
Skip to main content

I have a matrix table with 7 options someone can select for themselves and for their children. I want to get a count of how many times Column 2 was selected for all of the children, but exclude the selection for “yourself”. Is it possible to do a count of the specific answer in column 2 , but exclude the selection for “yourself” in the statments? I plan on using the count from this question as an embedded data field so I can compare the count to another field to make sure that the counts match.

 

Hi,

You could use scoring and create a category like this. You can then pipe in the score in an ED field.

 

 

Ok let me give it a shot. I thought scoring was only available at the end of the survey, but I think I just saw something that walked through how to embed the score as embedded data. I’ll let you know if I have any questions.

Thanks Vincent. Got it to work exactly as I needed. 

Terms & Conditions