I would like to configure a single stat panel to show the number of hosts, fulfilling a specific criteria.
On the influx cli my query work fine:
SHOW TAG VALUES CARDINALITY FROM "cpu" WITH KEY = "host"
name: cpu
count
-----
8
So I would like the single stat panel to show “8”.
Unfortunately so far I just managed to get N/A or “no value”.
Is there a way to configure single stat panel to handle a cardinality query accordingly?