Hello guys, I am stuck while trying to solve this particular issue. Here is the table I am looking at and the results I am trying to get to:
| ID | Time | Item |
| 5 | 08:00 | Facebook |
| 4 | 08:00 | Instagram |
| 5 | 08:30 | Facebook |
| 4 | 09:00 | Instagram |
| 5 | 09:30 | Facebook |
| 2 | 09:30 | Facebook |
| Channel | 08:00 | 08:30 | 09:00 |
| Facebook | 1 | 1 | 1 |
1x - 2
2x - 1
3x - 1
What I want to do is show where users are on facebook in either 1, 2, or 3 timeslots. For example above, user 5 was on Facebook 8:00, 8:30, and 9:00 while userid 4 was only on Instagram for 2 timeslots. For number 2, I want to show which users were using a channel on one timeslot, then who was on for two timeslots, and who were on for all three back to back.
Hopefully this makes some sense.
Thanks!
