Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am attaching a sample data file here.
My data contains sensor number, and 3 to 4 records for an hour for zoneCount (# of people) per meeting room.
my goal is to find occupancy utilization for the meeting rooms per hour per room. we have boardroom capacity and sq. ft value.
I am confused on where to start this calculation.
Hi , @jaeshin2
Do you have resolved it? If yes, you could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
Hi , @jaeshin2
I'm sorry that I'm still confused about the occupancy utilization for the meeting rooms per hour per room you want.
Can you specifically explain your calculation logic and the final result for a certain record row in the table?
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |