Forum

Occupancy Data - On...
 
Notifications
Clear all

Occupancy Data - One Record Per Hour of Day?

3 Posts
2 Users
0 Reactions
79 Views
(@shellp)
Posts: 13
Eminent Member
Topic starter
 

Hello

I am trying to create a graph showing how many people are in the Emergency Department per hour of the day.  So if someone was in hospital from 2:30 in the afternoon to 7:15 at night I would want a record for the hour of 1500, 1600, 1700, 1800 and 1900.  This will get tricky if the patient stays over more than one date.

Is this even possible?  Thanks.

 
Posted : 01/02/2022 5:01 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Shelley,

There is a similar question here that has been answered in the Microsoft Power BI forum that gives some options for solving this.

Mynda

 
Posted : 01/02/2022 6:34 pm
(@shellp)
Posts: 13
Eminent Member
Topic starter
 

Thank you!  

 
Posted : 08/02/2022 3:04 pm
Share: