Network Capactity Planning Graph

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.


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