Hi,
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.
Does anybody have a solution for this?
Thanks
Mike