• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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