Grouping dates 1

[sbbrown9924]

I am going to be building a graph showing the distribution of wait times in an ER waiting room. The dataset for this graph will come from a query that will count how many patients waited in a given time interval (ie, 20 patients waited less than an hour, 30, 1-2 hours; 15 2-3 hours, etc). I am able to calculate the time interval between the time a patient signs in and the time they are assigned to a bed by using this query.

SELECT *, DateDiff('n',TriageTime, InRoomTime) AS WaitingRoomTime Where....

How would I group and count the number of patients in each time interval (0-1 hour, 1-2 hours, 2-3 hours....)?

 

[Golom]

Try

Select Partition (DateDiff('n',TriageTime, InRoomTime)/60,
                  0, 10, 1) As [Waiting Time Range],

       Count(*)      As [Patients]

From   MyTable

Group By 
  Partition (DateDiff('n',TriageTime, InRoomTime)/60,
                  0, 10, 1)

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[sbbrown9924]

Golom;

This works great! Can you tell me what partition does? I can't find it in any reference material.

 

[Golom]

Check it out

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[sbbrown9924]

Golom;

Thanks!!!