InfluxDB 1.8 query help (show all values with same timestamp, and specific tag)

[fuba77]

Hi,
i got following data structure:

So each 12-16 min i send data to the influxDB with informations about several hosts.

I need to create a query, that counts all different “tag2” for each “tag1” (group by) and only for the last saved timestamp.

Can anyone help?

[fuba77]

has no one any idea?

[Giovanni_Luisotto]

This method should solve your problem

Best way to visualize number of distinct tags over time?

What is the best query to use to determine the number of distinct tags in a database? Is it possible to query the number of tags that have reported data within a given time range? Is it possible to create a chart in Grafana that shows how many distinct tags are reporting data over time? To show all the existing values for a tag you can use: SHOW TAG VALUES WITH KEY = "__YourTagName__" To have a count of the values you can use SHOW TAG VALUES CARDINALITY WITH KEY = "tag" (estimated, exact…