1 Reply Latest reply on May 3, 2018 9:18 AM by Joe Oppelt

# Most common combination of check all that apply

I have a survey where a customer can select up to 3 from a list of 10 options.

I am trying to determine if there is a somewhat easy way to determine which combinations of the 10 possibilities are most common.

I know that I could hand code every possible combination but that's over 120 possible combination so I'd rather not hand code it.

• ###### 1. Re: Most common combination of check all that apply

Consider making a calc that builds a string consisting of ones and zeros (or X and O, or any two distinct values) based on the three choices.

Value for Customer-A might look like "0001001010", and customer-B "0111000000", etc.  You can create a report of this calc, and give a count of the various values.

On the flip side, it would be pretty easy to sum up the number of Option-1 choices, and Option-2 choices, etc.. but this won't give you trends of popular combinations, which is what I think you are really going for.

A lot of this depends on how your data is shaped too.