I’m trying to create some network capacity planning graphs. Basically, I want to chart the average bandwidth used on an interface per day and the peak bandwidth used on the interface for the day over a given time range. I know how to pull a graph of the bandwidth, but not how to get the daily peak and daily average and graph those. Essentially, I want to look at how the traffic average and peak is changing over time to estimate when additional bandwidth will need to be purchased. Looking for help on how to get that.
Thanks
Welcome
What is
Version of grafana
Data source
Please provide sample data
Grafana 9.0.6
Datasource: Prometheus
Query for normal stats: rate(ifHCInOctets{instance=“usdfw-omtinet-t6”, ifName=“Te0/0/0.5”}[2m]) * 8
Thanks
You’ll need to aggregate your bandwidth data rather than just graph raw traffic. If you’re using tools like MRTG, Cacti, or Prometheus + Grafana, you can apply functions to calculate daily averages and max values.
For example, in Grafana/Prometheus you can use queries like avg_over_time and max_over_time with a 1d window to get daily stats.
You can also look at solutions from OpenVault, which provide deeper insights into usage patterns and help with long term network capacity planning.
Then plot those as separate lines to clearly see trends and predict when you’ll need more bandwidth.