Change CSV Interval

[vbbnaaron]

I want to pull a report each month that shows the average throughput each hour on a connection. I figured the best way to do this is by downloading the data in CSV format and then I can use excel to pull the statistics that I want. However I am finding that when I specify a custom 1 week time frame, I get 2 hour averages and when I specify a 1 month time frame I get 3 hour averages. What I want to be able to do is download a CSV with 1 hour averages for an entire month. Anyone have advice on how to accomplish that?

[paulgevers]

I want to pull a report each month that shows the average throughput each hour on a connection. I figured the best way to do this is by downloading the data in CSV format and then I can use excel to pull the statistics that I want. However I am finding that when I specify a custom 1 week time frame, I get 2 hour averages and when I specify a 1 month time frame I get 3 hour averages. What I want to be able to do is download a CSV with 1 hour averages for an entire month. Anyone have advice on how to accomplish that?

You will need to redesign your rrd files. The key search word here is aggregate.