Hope all are well. Apologies if these is a newbie question.
I have been trying to list all measurements name and cardinality in same result via a single query using influxQL on the chronograf explore feature.
I can do both separately but not together.
All measurements name
SHOW MEASUREMENTS ON "db_name"
All measurements cardinality grouped by measurement
SHOW SERIES CARDINALITY ON "db_name" group by "MEASUREMENTS"
Does anyone know if it is possible to do both queries as a single query showing the measurement and its corresponding cardinality value?
or an alternative way I could achieve such a result for a self hosted instance of grafana and influx.