Help on APM componet reporting - Report writer

HI,

I was trying to create an APM component report for a month , with daily summarisation. 

For example - I want '%committer bytes' (APM component) statistics plotted as each day's average value for the last month (so that we can see the trend- whether its going up or down), for each server.

Whatever option I select in report writer, I was not able get this report.

Please find the SQL queries for the closest report I got. In this report, its not able to give average value for a day. Its just giving 5 mins values for that component for a day. Thats a huge lot of data.

-------------------------------------------------------------------

SELECT TOP 4000
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
APM_AlertsAndReportsData.ComponentName AS Component_Name,
APM_ResponseTime.StatisticData AS StatisticsData,
APM_ResponseTime.DateTime AS DateTime

FROM
(Nodes INNER JOIN APM_AlertsAndReportsData ON (Nodes.NodeID = APM_AlertsAndReportsData.NodeId))  INNER JOIN APM_ResponseTime ON (APM_AlertsAndReportsData.ComponentId = APM_ResponseTime.ComponentID)

WHERE
( DateTime BETWEEN 40846 AND 40875.9999884259 )
 AND 
(
  (APM_AlertsAndReportsData.ComponentName = '% Committed Bytes In Use')

)

ORDER BY 5 ASC

--------------------------------------------------------

OUTPUT is below

But I want only one value for statistics data ( average for that day) for each day. 

Something like below - where statistics data should be the average of all values for that day.

Test-Committed Bytes

Could some one help me on this with correct SQL query?