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!
¡Resuelto! Ir a solución.
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 🙂