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