Summarizing by Time

#1 10-05-2005, 10:05 AM

Hello,

My data is a table of times, server names, and error counts. The time
stamps are by the second. I need to chart this as a summary of total
errors in 15-minute intervals. Then, I would like if at all possible
for the chart time to list only the hours. Any ideas on to do this?

Thanks in advance,

ChrisW

#2 10-05-2005, 12:05 PM

I'd probably create a histogram of the data somehow. You can use the
Histogram feature of Data Analysis Toolpak, but you'll need to install the
toolpak.

Another way would be to create a helper column and round the data up or down
to the nearest 15 minutes and then use a pivot table to get the information
you need.

"ChrisW" wrote:

> Hello,
>
> My data is a table of times, server names, and error counts. The time
> stamps are by the second. I need to chart this as a summary of total
> errors in 15-minute intervals. Then, I would like if at all possible
> for the chart time to list only the hours. Any ideas on to do this?
>
> Thanks in advance,
>
> ChrisW
>
>

#3 10-06-2005, 10:05 AM

Ok. I'll give it a shot. How do I round times to the nearest 15
minutes?

Barb Reinhardt wrote:
> I'd probably create a histogram of the data somehow. You can use the
> Histogram feature of Data Analysis Toolpak, but you'll need to install the
> toolpak.
>
> Another way would be to create a helper column and round the data up or down
> to the nearest 15 minutes and then use a pivot table to get the information
> you need.
>
> "ChrisW" wrote:
>
> > Hello,
> >
> > My data is a table of times, server names, and error counts. The time
> > stamps are by the second. I need to chart this as a summary of total
> > errors in 15-minute intervals. Then, I would like if at all possible
> > for the chart time to list only the hours. Any ideas on to do this?
> >
> > Thanks in advance,
> >
> > ChrisW
> >
> >

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)