Matrix Table: Count of selected choices across a column of statements | Experience Community
Skip to main content
Solved

Matrix Table: Count of selected choices across a column of statements

  • December 20, 2021
  • 5 replies
  • 569 views
A
Forum|alt.badge.img+2

Hello,
I haven't found the answer I'm looking for in other posts here so thought I'd try asking myself - I'm trying to grab the count of selections made underneath the column "Active/Contributing Member" in the matrix table pictured below so I can multiply it by a certain value. Trying to do the same for the second column. So if there are three different statements chosen under Active/Contributing Member...., the count should = 3. If 5 are chosen under chair, the count = 5. I need to store these values in two variables so I can access them later in the survey.
Unfortunately the piped text menu option "Selected Choices Count" sums selections across rows, not columns. I essentially need the same thing but for columns. Does anybody have any pointers on how I can do this? My guess is I might be able to add a click counter in the matrix table's javascript but not sure how I'd pass the variables to another page on the survey...
Appreciate your help.

Screen Shot 2021-12-19 at 10.24.58 PM.png

Best answer by darelS

I think you can do it via Javascript. Just pipetext the selected choices for the column then split it then get the length.

sample:
var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length;

    5 replies

    MatthewM
    Level 6 ●●●●●●
    Forum|alt.badge.img+30
    • MatthewM
    • Level 6 ●●●●●●
    • December 20, 2021

    I haven't tested this myself, but you might try the Transpose table option and see if counts sums the selections the way you want after applying that.
    image.png

      D
      Forum|alt.badge.img+2
      • darelS
      • Answer
      • December 20, 2021

      I think you can do it via Javascript. Just pipetext the selected choices for the column then split it then get the length.

      sample:
      var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length;

      S
      Forum|alt.badge.img+3
      • Sateesh
      • December 23, 2021

      Yes below is working fine.
      var count = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length

      A
      Forum|alt.badge.img+2
      • avunjian
      • Author
      • December 23, 2021

      MatthewM The transposition would have been the easiest solution, but unfortunately I get a 0 for the count, so I don't think it works. Thank you for the suggestion, though!
      Sateesh darelS That worked. Thank you.

      J
      Forum|alt.badge.img+4
      • Jamamel
      • April 1, 2022

      This is great and exactly what I'm looking for darelS Sateesh avunjian . Apologies for the following question is very basic and demonstrates how much of a noobie I am.
      Where is the best place to add the JS creation of this new variable that counts the number of statements chosen for a particular column? Would that during hte UnLoad phase of the same question?
      If so, would the full syntax look something like the following?

      Qualtrics.SurveyEngine.addOnUnload(function()
      {
         /*Place your JavaScript here to run when the page is unloaded*/
         var count_var = "${q://QID1/ChoiceGroup/SelectedChoicesForAnswer/1}".split(",").length

         Qualtrics.SurveyEngine.setEmbeddedData("embedded_var_name", count_var)
      });

      Terms & ConditionsAccessibility statement