Selection to show associations

[Anonymous]

I appreciate this query is fairly vague but wondering if someone could point me in the right directions. I have a table which a unique key called feedback_id. The data is from a survey where the respondents were able to select any number of the 6 available options (labelled A-F). The data is tabulated as follows,

feedback_id	Question_1
123	A
124	B
124	D
125	A
125	C
125	E
126	B
127	F

I'd like to have a look at where people have selected multiple answers and see if there is an association between the choices. Id like to see of those that answered option A what are the other options selected, however once I apply the filter it removes all of these options. Would it be possible to select 'A' but have the filter applied on the feedback_id's which contain option A which would then leave all the other options.

If anyone could suggest where I should look for more information or have a solution it would be really appreciated. Thanks

[ogautier62]

Hi

make a sheet with in dimension :

1:     aggr(count({1} question),feed_id)

2:     feed_id

in expression :

count(distinct feed_id)

A appears twice : once alone, once with two other responses

regards

[Anonymous]

This gives me a numerical breakdown but I need to be able to actually view which answers its appearing with instead of just the numbers. If I was to create a bar chart with Question_1 as the dimension and count(feedback_id) as the measure but then select the question as a filter I'd like to still see the count of the other options but only if they have been had in conjunction with option A

[ogautier62 · Accepted solution]

may be this :

in load, add a new field q2 wich is equal to question,

then in dimension first column,

and in expression second one

here you see that with A,  C and E are associated for same ID (one time each)

[ogautier62]

Hello,

is this you expected ?

[Anonymous]

Hi Olivier,

I thought this might be the only way possible. I have seen something similar before but was trying to avoid duplicating fields. Thank you for your help