First a little background:
Every 5 minutes we store all interface counters of our router (about 200 different interfaces) with the following data:
field: bps (values)
tag: routerName + interfaceName
Now i want to query influx to see the 10 most excessive interface over a timeperiod (for e.g. 24h).
So a sum of bps over the 24h per interface and only show the top 10 of these interfaces.
Anyone a solution for me?