Graph number of hosts

Hi,

I would like to graph the number of host of a specific measurement in INfluxDB. For some reason I do not get measurements of all my hosts.

I found this request to get all my host names
SHOW TAG VALUES FROM “main_current” WITH KEY = “host”

Now, I want to plot this number of host in grafana

Thank you

add group by host to your query