# Using top(1) but still get more than one value

**URL:** <https://community.influxdata.com/t/using-top-1-but-still-get-more-than-one-value/6643>\
**Category:** Systems\
**Created:** [September 18, 2018, 6:24am UTC](https://community.influxdata.com/t/using-top-1-but-still-get-more-than-one-value/6643 "2018-09-18T06:24:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![PatricF](https://avatars.discourse-cdn.com/v4/letter/p/57b2e6/32.png) [@PatricF](https://community.influxdata.com/u/PatricF)\
**Post date:** [September 18, 2018, 6:24am UTC](https://community.influxdata.com/t/using-top-1-but-still-get-more-than-one-value/6643/1 "2018-09-18T06:24:59Z")

</div>

Hi,

I use this line to get the highest value for that month:

```
SELECT top("value", 1) AS "Users" FROM "metrics" WHERE ("host" = 'ServerName' AND "performanceLabel" = 'Users' AND "time" >= '2018-08-01' AND "time" <= '2018-08-31') AND $timeFilter GROUP BY time(4w) fill(null)

```

I use this in a Table panel in Grafana but somehow I get more than one value.  
I’ve tried to change the **4w** to 5,6,7 etc. and the only time I get only one value is when I use **7w** , but when I try **8w** I get two values again.

Does anyone know why it behaves like this?

Thanks,