topic Re: Selection to show associations in App Development

Selection to show associations

Anonymous — Tue, 03 Jul 2018 10:30:03 GMT

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

Re: Selection to show associations

ogautier62 — Tue, 03 Jul 2018 11:41:42 GMT

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

Re: Selection to show associations

Anonymous — Tue, 03 Jul 2018 12:13:45 GMT

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

Re: Selection to show associations

ogautier62 — Tue, 03 Jul 2018 13:13:56 GMT

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)

Re: Selection to show associations

ogautier62 — Wed, 04 Jul 2018 07:55:00 GMT

Hello,

is this you expected ?

Re: Selection to show associations

Anonymous — Wed, 04 Jul 2018 08:45:05 GMT

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