Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
pgarcia75
Contributor III
Contributor III

Evaluate the number of races per hours per hour, per day, per week and per month

Hello

I try to analyze the service performed by stretcher bearers in a hospital.


A stretcher's race is characterized by a reference, a date and time of departure and a date and time of arrival.


I loaded a table with these 3 fields: Ref (unique reference), DateDep (date and time of departure DD / MM / YYYY HH: MM) and DateArr (date and time of arrival DD / MM / YYYY HH: MM )


I would like to evaluate the number of races per hours per hour, per day, per week and per month.


How can I do ?


Thank you for your help


Patrice

1 Reply
swuehl
MVP
MVP

Not quite sure what you mean with 'evaluate the number of races per hours per hour'. Could you elaborate?

Maybe by posting some input data and your expected result?

Maybe you are looking for something similar like

Re: How to count how many people was/are in the building??

I would start with creating records for the most granular time period (hour) for each Reference ID using a WHILE loop.

Maybe something like

Utilization per hour