Calculating slots

[mroker]

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!

[PhilipMannering · Accepted solution]

Hi @mroker 

Maybe this solves your problem?

[atcodedog05]

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 😀👍

[BrandonB]

Maybe something like this:

 

 

[mroker]

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.

[PhilipMannering]

@mroker Like this?

Could you mock up your exact answer? I'm confident it is possible.

[atcodedog05]

Hi @mroker 

Are looking for something like this

Or

If not please provide an expected answer

We can help you out 🙂