Room utilization

[msc228]

Hi all,

I have datasets about various Buildings (Building 1 through Building N) and various rooms within each building. We also know the times for which each room was used as well as the number of people in that room within that window. Please find a simplified version of my data below.

Building	Room Number	Date	TimeStart	TimeEnd	NoAttendees
Building 1	Room 1	Jan 1, 2018	10:00 AM	10:05 AM	1
Building 1	Room 2	Jan 1, 2018	10:01 AM	10:05 AM	2
Building 1	Room 3	Jan 1, 2018	10:02 AM	10:10 AM	3
Building 1	Room 4	Jan 1, 2018	10:03 AM	10:10 AM	4
…	…	...	...	...	...

I am trying to find to calculate the maximum number of people in each building at any time on each day. In the above example, I have a maximum of 10 people in the Building 1 (1 + 2 + 3 + 4); in the above example, this maximum occurs from 10:03 AM - 10:05 AM. How can this be calculated within Alteryx?

Thank you.

[Dynamomo · Accepted solution]

Hi @msc228 ,

Sorry, I'm not a programmer but when I saw this problem I immediately saw the need for a generate rows tool (generate a record for every minute between the start and end times for every record).  Then, now that the records are at the minute level, you use the Summarize to group on the time and sum up the number of attendees.

I have attached a workflow to illustrate.

[msc228]

Hi Dynamomo,

Apologies, I'm having trouble opening the file. I'm on an older version of Alteryx (11.03), so I believe that may be causing the issue. However, I believe I understand how to replicate what you're describing. I will test it now. 

[Dynamomo]

Here is a screenshot of the workflow and generate rows tool

[msc228]

Hi Dynamomo,

That worked wonderfully. Thank you for your help.