4 Replies Latest reply: May 6, 2011 10:18 AM by Deepak Vadithala RSS

    *** Filter data based on selected fields in Set Analysis / Using Indirect Analysis ***

    Deepak Vadithala

      Dear All,

       

      I am working on a survey project. I had data for different activities like...

       

      • Travel
      • Away from Home - Shopping
      • Away from Home - Entertainment
      • Away from Home - Eating

       

      I have this data for each hour of the day and each day of the week. Now I wanted to look the behaviour of my audience. I mean I am using a simple set analysis expression to display a bar chart...

       

      COUNT({$<TimeStampValue = {$(=($(vMaxCurrentTime)))} , Q_No ={'Q1'} >} Resp_ID)

       

      Now I wanted to look at the behaviour of the same audience for next & previous hour. So I had created a variable which calculates the previous & next hour based on the time selected by the user. And if the user selects a specific time, day & activity.

       

      For example : Selecting the audience who travel at 7AM on Sunday. And if there are 1000 responses for the same.

       

      *** Now I wanted to see the behaviour of these 1000 respondents in previous hour & next hour? ***

       

      I hope it all makes sense. Your help/suggestions are much appreciated

       

      Many thanks in advance.

       

      Cheers - DV