Mapping constant sum from a matrix table | XM Community
Solved

Mapping constant sum from a matrix table

  • 13 March 2018
  • 5 replies
  • 427 views

Userlevel 6
Badge +45
I have several questions in a survey that are in a matrix table where respondents enter whole numbers and they are added along each row to reflect a constant sum. This works fine if I'm exporting the raw data, but I cannot find a way to map this into Vocalize. Has anyone run up against this issue before? Have you found a way to make it work? Thanks in advance!
icon

Best answer by AnthonyR 14 March 2018, 17:45

View original

5 replies

Userlevel 4
Badge +3
You can, with Javascript, set the sums to an Embedded Data field that can be represented in your reporting services! Are you familiar with the Javascript API? If not, I could walk you through it!
Userlevel 7
Badge +7
> @Michael_Campbell_RedPepper said:
> You can, with Javascript, set the sums to an Embedded Data field that can be represented in your reporting services! Are you familiar with the Javascript API? If not, I could walk you through it!

If you are going this route, you could just as easily write the sums with piped text math.

https://www.qualtrics.com/support/survey-platform/survey-module/editing-questions/piped-text/math-operations/
Userlevel 6
Badge +45
@AnthonyR and @Michael_Campbell_RedPepper

It's not the sums I am interested in mapping as much as the numbers entered that add to the sums. No matter which data type I select in Vocalize, the questions/answers do not show up as being available for mapping.
Userlevel 7
Badge +7
> @VirginiaM said:
> @AnthonyR and @Michael_Campbell_RedPepper
>
> It's not the sums I am interested in mapping as much as the numbers entered that add to the sums. No matter which data type I select in Vocalize, the questions/answers do not show up as being available for mapping.

Hmm, what about setting up embedded data fields for each entry box then, and using those as your data for mapping
Userlevel 7
Badge +6
> @VirginiaM said:
> @AnthonyR and @Michael_Campbell_RedPepper
>
> It's not the sums I am interested in mapping as much as the numbers entered that add to the sums. No matter which data type I select in Vocalize, the questions/answers do not show up as being available for mapping.

Hi @Virginia,

I just want to say that I feel your pain. I just spent the last 2.5 days working on creating a data intake form with numerous math operations and javascript code in order to get it to function the way I want... only to try find out that the data entered is marked as "text" and can't be changed. I now have to either map each data value to an ED field in the survey flow, or rebuild my intake form from scratch.

grrrrrrr.

Leave a Reply