aggregate daily data by hour over a 15 or 30 day period

Hi, I am trying to create a report for a server metric that is aggregated by hour (0-24) for a period of 30 days. When I aggregate the attribute value in the chart being created, it seems inaccurate. It shows the same number for each server across the 24 hour period. I am guessing that I have it configured wrong either in the query or the chart or both and am looking for help as to how to create the chart in order to see the data as expected.

It is entirely possible the data is correct, but it is hard to imagine that every hour has the same aggregated value for the period (15 days for this one). We have another reporting tool that paints a very different picture where one hour is a value of 3, next hour is 10, next hour is 0 and so on for 24 hours. This would suggest the server has been running a particular process for x number of days for the entire day. The metric being collected is a configuration that sets a 1 for process running and 0 where it is not. So the collection of 1s over the course of a day broken down by hour would be where we want to aggregate the values for the 15 or 30 day period.

I tried just dropping the metric in the Color section, but it yields the same result as the analysis. Does it make sense what I am asking? Am I doing it incorrectly? The SQL of the report is below. I don't know the way to extract just the hour in an SQL statement, so the hour designation is set in the UI by formatting the attribute to display 24 hours. Any help is appreciated.

SELECT DISTINCT

"VW_CONFIGDATA"."ATTRUNIQUENAME",

"VW_CONFIGDATA"."DEVICENAME",

SUM("HOURLY_DATA"."VALUESUM") / SUM("HOURLY_DATA"."VALUECOUNT"),

MAX("HOURLY_DATA"."VALUEMAX"),

MIN("HOURLY_DATA"."VALUEMIN"),

"HOURLY_DATA"."TIMERECORDED"

FROM "HOURLY_DATA"

INNER JOIN "VW_CONFIGDATA"

ON(

"VW_CONFIGDATA"."SERVER_ID" = "HOURLY_DATA"."SERVER_ID"

AND "VW_CONFIGDATA"."MOTYPEID" = "HOURLY_DATA"."MOTYPEID"

AND "VW_CONFIGDATA"."ATTRID" = "HOURLY_DATA"."ATTRIBUTEID"

AND "VW_CONFIGDATA"."ITEMID" = "HOURLY_DATA"."MOINSTID"

)

WHERE (

"VW_CONFIGDATA"."DEVICENAME" LIKE '%2.qa%'

AND "HOURLY_DATA"."TIMERECORDED" >= TRUNC(sysdate)-15

AND "VW_CONFIGDATA"."ATTRUNIQUENAME" LIKE 'PROCCOUNT'

)

GROUP BY

"VW_CONFIGDATA"."ATTRUNIQUENAME",

"HOURLY_DATA"."TIMERECORDED",

"VW_CONFIGDATA"."DEVICENAME"

ORDER BY

"HOURLY_DATA"."TIMERECORDED"