Influxdb: [feature request] Count of different tag values

[TechniclabErdmann]

Hi together,

with the query

SHOW TAG VALUES WITH KEY = id 

I get a list of all different tag values of my database.

Now I need to count them. An example, there query above returns:

name:idTagValues
----------------------- 
id
myId1
myId2
myId3

I need the result "3". Is their any way to get it? I tried some possibilities but everything fails:
An idea for further releases is to combine two queries, so the second one references at the first query's result:

SHOW TAG VALUES WITH KEY = id; SELECT count(id) FROM idTagValues

Any idea to realize my request?

Thanks :-)

[beckettsean]

There's no way to do this currently.

[TechniclabErdmann]

Maybe an idea for further release? I would love to see that I can reference to a query result from an other query.

[beckettsean]

@The-Nik yes, I changed this to a feature request and left it open so we can discuss whether and when to implement this feature.

[rvrignaud]

This would be useful for us too +1

[larrywalker]

+1 for us also. The only "workaround" is to store data as a tag and field. Seems wasteful.

[wojciechszela]

+1 would help us a lot

[mouseratti]

I need this too

[sbengo]

+1

[kbespalov]

+1.

[wegel]

+1

[saboteurkid]

+1

[TechBK]

+1

[codepattern]

+1

[dstreppa]

+1

[lpalm]

+1

[vw-d3]

+1

[ngong]

+1

[supershal]

+1

[gargooza]

+100

[StephenPCG]

+1

[trollfred]

+1

[cloudnull]

+1

[jsternberg]

We're going to implement this with #7195.

[kainoj]

It seems that update is on the way but I found this nested query:

SELECT count("count") FROM (SELECT count(temperature) FROM mydb GROUP BY sensor)

where sensor is a tag I want to count and temperature is float value associated with the tag.

It looks weird but it works :laughing:

[jasper-zhang]

#8636 SHOW CARDINALITY functionality is coming.

[mvadu]

@benbjohnson #8636 looks like merged (on Aug 16 itself) , but on latest stable release v1.3.7 [2017-10-26]
SHOW TAG VALUES CARDINALITY FROM "<measurement>" WITH KEY = '<tag key>' or SHOW TAG KEY CARDINALITY is not working. e.g. later gives me error error parsing query: found KEY, expected KEYS, VALUES at line 1, char 10

[timhallinflux]

SHOW CARDINALITY is available starting with the v1.4 release.

[vlyalcin]

I know the issue has been closed, but I find it useful to share a link and example since this page still appears on google search.

This solves the question: https://docs.influxdata.com/influxdb/v1.8/query_language/spec/#show-cardinality

Example in my case:

SHOW TAG VALUES CARDINALITY WITH KEY = "Client_Name"
name: Vodafone_Backups_All_Dashboard
count
........
6062