Single stat panel for cardinality query for Influx possible?

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?

Thanks in advance,
TriCX

Cardinality query produces single value result, but you need timeseries input for singlestat. Time dimension is missing.

I see. Is there an alternative or workaround?
Is it possible to define a continuous query to generate a time series from the cardinality?

I use dashboard variable, where you can have this type of queries:

Hi @jangaraj,

This is interesting. Could you provide a bit more on how you use the above for those type of queries?

1 Like