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

**URL:** <https://community.influxdata.com/t/display-only-the-10-interfaces-with-the-highest-sum-over-a-time-frame/5843>\
**Category:** Systems\
**Created:** [July 10, 2018, 5:40pm UTC](https://community.influxdata.com/t/display-only-the-10-interfaces-with-the-highest-sum-over-a-time-frame/5843 "2018-07-10T17:40:03Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![frazer](https://avatars.discourse-cdn.com/v4/letter/f/4bbf92/32.png) [@frazer](https://community.influxdata.com/u/frazer)\
**Post date:** [July 10, 2018, 5:40pm UTC](https://community.influxdata.com/t/display-only-the-10-interfaces-with-the-highest-sum-over-a-time-frame/5843/1 "2018-07-10T17:40:03Z")

</div>

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