• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

Sessions Before And After In Web Intelligence

I'm trying to get "sessions" to line up in my Web Intelligence report. I have a V_Session variable that goes by start and end times.

I have a break on the V_Session to show people who are in that particular session. I'd like to know if that person will be in another session after that or was in a prior session.

I'm looking for a variable at the report level as I don't have access to create custom SQL. I've attached a spreadsheet in hopes you get the idea. Thanks!
Sessions.xlsx
0
tracyms
Asked:
tracyms
  • 2
1 Solution
 
tracymsAuthor Commented:
I know this is hard one - it's like vlookup in excel. I'm still working to figure it out but it seems not to be a question that can be answered. Should I close this question?
0
 
tracymsAuthor Commented:
Fyi - I was able to solve this after much research and trial and error by using a crosstab and the following formula:

([Person] ForEach ([Session Name];[Session Start Date];[Meeting Start Time])) In ([Session])
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now