Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am working on a survey project. I had data for different activities like...
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
Finally, I got it working with trail & error method.... My logic was right but my syntax was incorrect.
Here is what I need
COUNT
({$<TimeStampValue={$(=($(vPreviousHour)))},
Q_No = {'Q1'},
Label_Text = {1} Label_Text,
Resp_ID = p({$<TimeStampValue={$(=($(vMaxCurrentTime)))}>} Resp_ID)>}
Resp_ID)
Many thanks to those who read this post!
Cheers - DV
Also, I had tried to use indirect analysis. But I can't get it working
I can explain more if you need to know more details...
Cheers - DV
Adding to my previous post :
I had tried using the Indirect Analysis and can't seem to get the syntax right. Please can someone look into this one...
COUNT(({<TimeStampValue={$(=($(vPreviousHour)))},
Resp_ID = p({<TimeStampValue={$(=($(vCurrentTime)))} Resp_ID>})
Resp_ID)
Thanks - DV
I had got the syntax right, however it does not filter the data based on current selection. Please can someone look this for me...
COUNT({$<TimeStampValue={$(=($(vNextHour)))},
Q_No = {'Q1'},
Resp_ID = p({$<TimeStampValue={$(=($(vCurrentTime)))}>} Resp_ID)>}
Resp_ID)
This expression with Indirect Set Analysis returns zero . Which is incorrect...
Thanks - DV
Finally, I got it working with trail & error method.... My logic was right but my syntax was incorrect.
Here is what I need
COUNT
({$<TimeStampValue={$(=($(vPreviousHour)))},
Q_No = {'Q1'},
Label_Text = {1} Label_Text,
Resp_ID = p({$<TimeStampValue={$(=($(vMaxCurrentTime)))}>} Resp_ID)>}
Resp_ID)
Many thanks to those who read this post!
Cheers - DV