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

Count specific column from matrix and exclude specific row

  • August 13, 2025
  • 3 replies
  • 27 views

Forum|alt.badge.img+6

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.

 

Best answer by vgayraud

Hi,

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

 

 

3 replies

vgayraud
QPN Level 6 ●●●●●●
Forum|alt.badge.img+58
  • QPN Level 6 ●●●●●●
  • 549 replies
  • Answer
  • August 14, 2025

Hi,

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

 

 


Forum|alt.badge.img+6
  • Author
  • Level 2 ●●
  • 20 replies
  • August 14, 2025

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.


Forum|alt.badge.img+6
  • Author
  • Level 2 ●●
  • 20 replies
  • August 14, 2025

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