Select Statement - Average of Max

[mrichey]

I'm using the statement below to pull out the MAX CPU reading fom the hourly tests for each day in August. Is there any way to alter the statement to see the average of the MAX's for each server in August? I'm using crystal reports and I'm having to insert an AVG summary on the MAX"TIV_AGG"."W.PCENTPROCTIME"" field. Because that is a 2nd pass function, I can't chart on it. Any suggestions appreciated.

SELECT "TIV_AGG"."S_DATE", "TIV_AGG"."SERVER",MAX ("TIV_AGG"."W_PCENTPROCTIME")
FROM "TIVOLI"."TIV_AGG" "TIV_AGG"
WHERE "TIV_AGG"."S_DATE" BETWEEN '20040801' AND '20040831'
GROUP BY "TIV_AGG"."S_DATE", "TIV_AGG"."SERVER

 

[Axoliien]

When I look at your query, it looks like you are pulling the maximum value of the hourly tests for EVERY DAY in August, not EACH DAY in August, am I correct?

Anyways, I think what you want it the aggregate functions using the GROUP BY clause.