Calculate peak time

  • Thread starter Thread starter Kay Starnes
  • Start date Start date
K

Kay Starnes

I have my time seperated out in but need to calculate peak times from the
data. Is it possibe?
 
It seems you droped a few words out of your sentence when you typed.
Give some more information -- table and field names with data type; sample
data; what you want the results to look like.
 
So I did...sorry; I have a Date time field mm/dd/yyyy hh:00:00 am format and
have pulled out the times between 5pm and 5 am. I need to find out what the
PEAK time for activity was for the time periods.

1- Need overall peek time for the whole group the time segment with the
highest volume. Problem is there are no 2 times alike so I need to look at
time segments then volumes during those times.

I think I may have answered my question. I need to break it down into time
segments then look at volumes during those times.

:) Thanks Karl
 
The query below pulls data between two dates,
divides each day into hours,
divides each hour into 15 minute segments, and
counts activity per 15 minute interval.

SELECT Format([Date open],"hh") AS [Hour of day], Partition(Format([Date
open],"n"),0,59,15) AS [Count-per-interval], Count([Change Requests].[Date
open]) AS [CountOfDate open]
FROM [Change Requests]
WHERE ((([Change Requests].[Date open]) Between #8/25/2008# And #8/26/2008#))
GROUP BY Format([Date open],"hh"), Partition(Format([Date open],"n"),0,59,15);
 
Sorry Karl,
I am sure that would work but I am not there yet. I ran it with multiple
queries and pulled it out. I didn't know how or where to put what yo told
me. I tried a module but messed it up.

Thanks fo responding.

KARL DEWEY said:
The query below pulls data between two dates,
divides each day into hours,
divides each hour into 15 minute segments, and
counts activity per 15 minute interval.

SELECT Format([Date open],"hh") AS [Hour of day], Partition(Format([Date
open],"n"),0,59,15) AS [Count-per-interval], Count([Change Requests].[Date
open]) AS [CountOfDate open]
FROM [Change Requests]
WHERE ((([Change Requests].[Date open]) Between #8/25/2008# And #8/26/2008#))
GROUP BY Format([Date open],"hh"), Partition(Format([Date open],"n"),0,59,15);


Kay Starnes said:
So I did...sorry; I have a Date time field mm/dd/yyyy hh:00:00 am format and
have pulled out the times between 5pm and 5 am. I need to find out what the
PEAK time for activity was for the time periods.

1- Need overall peek time for the whole group the time segment with the
highest volume. Problem is there are no 2 times alike so I need to look at
time segments then volumes during those times.

I think I may have answered my question. I need to break it down into time
segments then look at volumes during those times.

:) Thanks Karl
Click to expand...
Click to expand...
 
What I posted is a SQL statement of a query.
If you will post your table and field names with datatype I'll tell you how
to build a query in design view.

You also need to tell what are the time segments you want the data in -
hourly, half hour, 6 hour, etc.

Kay Starnes said:
Sorry Karl,
I am sure that would work but I am not there yet. I ran it with multiple
queries and pulled it out. I didn't know how or where to put what yo told
me. I tried a module but messed it up.

Thanks fo responding.

KARL DEWEY said:
The query below pulls data between two dates,
divides each day into hours,
divides each hour into 15 minute segments, and
counts activity per 15 minute interval.

SELECT Format([Date open],"hh") AS [Hour of day], Partition(Format([Date
open],"n"),0,59,15) AS [Count-per-interval], Count([Change Requests].[Date
open]) AS [CountOfDate open]
FROM [Change Requests]
WHERE ((([Change Requests].[Date open]) Between #8/25/2008# And #8/26/2008#))
GROUP BY Format([Date open],"hh"), Partition(Format([Date open],"n"),0,59,15);


Kay Starnes said:
So I did...sorry; I have a Date time field mm/dd/yyyy hh:00:00 am format and
have pulled out the times between 5pm and 5 am. I need to find out what the
PEAK time for activity was for the time periods.

1- Need overall peek time for the whole group the time segment with the
highest volume. Problem is there are no 2 times alike so I need to look at
time segments then volumes during those times.

I think I may have answered my question. I need to break it down into time
segments then look at volumes during those times.

:) Thanks Karl

:

It seems you droped a few words out of your sentence when you typed.
Give some more information -- table and field names with data type; sample
data; what you want the results to look like.

:

I have my time seperated out in but need to calculate peak times from the
data. Is it possibe?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top