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 | |
4 | 08:00 | |
5 | 08:30 | |
4 | 09:00 | |
5 | 09:30 | |
2 | 09:30 |
Channel | 08:00 | 08:30 | 09:00 |
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!
Solved! Go to Solution.
Hi @mroker
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Thanks, this is really close with what I had wanted. I had actually wanted to see per channel which ones have 1, 2, and 3. So in other words, for timeslot 8, how many persons were on once, twice, 3 times, etc for each time slot. I am not sure if that is possible.
Hi @mroker
Are looking for something like this
Or
If not please provide an expected answer
We can help you out 🙂