InfluxQL series cardinality

Hi,
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.

Best,
Mark

Hello @marklw16,
This isn’t possible with 1.x but you can achieve this with InfluxDB Cloud.

ok cool, thanks for your help and response.
Best,
Mark