I have a report for historical Transaction duration times that shows the exact same values for the Min, Max and Avg duration. What have I done wrong? See screen shot.
Can you post up a screen shot of the Select Fields tab. Seems to me that you haven't put MIN, MAX or AVERAGE for the function.
In the example for bps below, without the AVERAGE or MAX functions, both values will be the same.
It's nothing that you've done wrong. The data has yet to be summarized. This is data that is still within your Detail data retention setting. As such, for each collected time stamp, there hasn't been enough summarization to find the min or max values. Once this data is summarized, then the min, max, and avg will have different values. You can see this if you run the same report but for Last Month.
Regards,
Matthew Harvey
Loop1 Systems
http://www.loop1systems.com
I am still seeing the same behavior from this report after 7 days, but I will wait one more day to see if the values start to diversify. However, I was thinking about what you said, and it still does not make sense that the MIN, MAX, and AVG values should be the same. That would indicate that every polled value over the last seven days was exactly the same. Highly unlikely would'nt you say?
For the specific timeframe that is being pulled no. The report, unless you are summarizing, is going to show every data point during the time the device was polled. Without summarization each data point will have the same values. So all of the 1st data point values will be the same, all of the 2nd data point values will be the same. Once the information is summarized, then a min and max can be determined.
The numbers don't change whether Summarization is selected or not.
