Bar gauge with MySQL Table

[alessandro2]

Hi
I’m trying to do a Bar gauge attached to a MySQL Query.

This is the query to show the TOP 10 hosts with a counter:

SELECT
host as “hostname”,
count(host) AS “total”

FROM events
WHERE
$__timeFilter(timestamp)
GROUP BY host
ORDER BY total DESC
LIMIT 10

I’m able to show the Bar gauge but I’m not able to show the correct labels with the hostname (it report always “total” the alias field name.

How can I report the correct label from the host field?
I’ve tried to use the Field → Display name option but without any success.

Someone can help me?

Thanks
Alessandro

[codlord]

May be other ways to achieve this with variables in the display name but I set Format as Time series with queries like the one below selecting time/metric/value. Works for me:

SELECT now() as time,
host as metric,
count(1) as value
from...
where...

[alessandro2]

Thank you very much!
It works!