Create embedded data by individual matrix table statement and multi-select statements | XM Community
Skip to main content

I have a matrix table where each statement is a unique person and I want to know what music services each person uses (Assume there are 5 people). In the embedded data I want to create a flag of each person and if they use multiple services, one service, or none. What would be the cleanest way to do this? I tried to use the scoring tool, but it sums up all of the 5 people into one score.  So for an example if Person 1 uses only Spotify it would be flagged as a single service, if person 2 selects spotify, apple music, youtube music then they would be flagged as a multi-service user. If they select “I don’t have my own music service” (Exclusive) They would be None.

 

Hi @gsheppard ,

 

One alternative would be setting branch condition in survey flow but it may be messy and tedious as you would likely be required to add all possible combinations of the available options.

 

For example, a-d option with d being none of the above.

if a is not selected, b is not selected, c is not selected and d is selected, embedded data resultvalue= none.

 

if a is selected, b is not selected, c is not selected and d is not selected,

or if a is not selected, b is selected, c is not selected and d is not selected,

or if a is not selected, b is not selected, c is selected and d is not selected,

embedded data resultvalue= single.

(Number of conditions to set for single may increase depending on number of options available.)

 

if a is selected, b is selected, c is selected and d is not selected,

or if a is selected, b is selected, c is not selected and d is not selected,

or if a is selected, b is not selected, c is selected and d is not selected,

or if a is not selected, b is selected, c is selected and d is not selected,

embedded data resultvalue= multi.

(Number of conditions to set for multi may increase a lot depending on number of options available due to possible combinations)


Yeah I did do some branch logic on some other questions, but this one because there are so many variations it would get to be a large survey flow, so I was trying to see if there was any other alternatives as well.


Leave a Reply