Display only the 10 interfaces with the highest sum over a time frame


#1

Hi,

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?

Thanks,
D