I have conducted a survey and stored the data using star schema.
My fact table looks like this..
ResponseID
Question_ID
Answer_ID
1
Q1
1
1
Q2
2
1
Q3
4
1
Q4
1
2
Q1
5
2
Q2
1
2
Q3
1
2
Q4
1
3
Q1
1
3
Q2
1
3
Q3
1
3
Q4
1
4
Q1
1
4
Q2
2
4
Q3
2
4
Q4
1
I have 4 charts, each one for a question.
Requirement: When I select chart 1 for a response (lets say I selected Answer_ID=1), I want to show all the response_IDs in chart 2,3,4 that answered '1' in Q1.
Current situation: When I selected Answer_ID=1, it filters the whole data set with (Question_ID =Q1 & ANswer_ID=1) and blanks all other charts.
I want filtering within rows instead of columns. One of achieving this is to make all the questions a 'dimension' but I will lose my schema in that case.
