Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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
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)
Hello,
is this you expected ?
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