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:
host as “hostname”,
count(host) AS “total”
GROUP BY host
ORDER BY total DESC
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?