0 Replies Latest reply: Jul 4, 2016 2:14 AM by Mike Anand RSS

    Cross Filtering in Survey Data

    Mike Anand

      Hi,

       

      I have conducted a survey and stored the data using star schema.

      My fact table looks like this..

       

         

      ResponseIDQuestion_IDAnswer_ID
      1Q11
      1Q22
      1Q34
      1Q41
      2Q15
      2Q21
      2Q31
      2Q41
      3Q11
      3Q21
      3Q31
      3Q41
      4Q11
      4Q22
      4Q32
      4Q41

       

      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