• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • 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!
  • 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?
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])
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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