Bar Gauge Panel - How to Display top 3

Hey Guys,

I’m trying to display the following data coming from InfluxDB, where HOSTNAME is a tag and download is a Field:


I can easily get the data I want from influx with the query below:

select top(lastDown,hostname,3) from (SELECT last(“download”) as lastDown FROM “” group by hostname)

and also I can properly display it on Grafana using a Table object.

The problem is when I try to present the data using a Bar Gauge panel it doesn’t work and shows like this:

As you can see above, where it should show hostname it displays TOP.

Can anyone help me figure this out ? Thanks in advance