Avg and Peak Traffic Rate Report Issues. Has anyone experience this?

I created a report on report writer to show me the interfaces in a set of 9 switches who's average bps was higher than 50 Mbps. The report displays the average received, transmit bps and the peak received, transmit bps. I used the average and peak traffic rate report that comes with Orion. I just added my filters, I noticed that the values that Orion gives me for the average are exactly the same or almost the same as the peak value when summarizing for a day. When I look at the graph the data the report gives me doesn't match the graph.

This is the info I have in the report

Select Fields Tab

Node ID

Interface ID

Node Name sort ascending

Location

Interface Caption sort ascending

Average Receive bps sort * function AVERAGE

Peak Receive bps sort * function MAX

Average Transmit bps sort * function AVERAGE

Peak Transmit bps sort * function MAX

(Almost the exact same information the canned report had)

Filter Results

Select records where all...

Select records where any...

Records where System Name contains ###### (specific tag number)

Records where System Name contains ######

Records where System Name contains ######

Records where System Name contains ######

Records where System Name contains ######

Records where System Name contains ######

Records where System Name contains ######

Select records where any...

Records where Average Receive bps is greater than or equal to 50000000

Records where Average Transmit bps is greater than or equal to 50000000

Top XX

Show all records

Time Frame

Last 30 Days

Summarization

Summarize the Results by hour, date, month, etc (I selected Date and Beginning) I want one record per day so I expect to get an average for the whole day

Here is one of the results I got (edited for sensitive information)

Now when I look at the graph for the first row the actual average for that day was not 98 Mbps. The 98 Mbps was a one 5 min data point after 6:00 PM. If I export the data the graph shows and I calculate the average using all the 5 min data points the average for that day is almost .5 Mbps. Why am I getting 98 Mbps as the average? Is my expectation of the summarization option wrong? why?

I need this report to work so I can show a customer that he doesn't need Gigabit access layer switches. They are telling me that they need more bandwidth because the network is "slow"... their switch ports are "saturated". I'm telling them that their problem is probably the application that we need to troubleshoot the app but they don't want to listen. I told them that I would provide a bandwidth report to show them how much of the provided bandwidth they are using but I can not provide bad data.

Thanks for any help I can get.