Trying to get Count Distinct across multiple columns

query
influxql
influxdb
#1

Hey Folks,

Trying to figure out an equivalent for the following with influx.

SELECT COUNT(DISTINCT Useragent), COUNT(DISTINCT CountryId), COUNT(DISTINCT resolverID) from table where (time >= ‘2018-01-01 00:00:00’ AND time < ‘2018-01-02 00:00:00’)

Useragent, CountryID and ResolverID are all tags. I found SHOW TAG KEY CARDINALITY but how can I use this for multiple Tags?

If I have to revert these tags to fields how do we keep index performance with multi-tb datasets

This is probably something that is easy so please forgive if this is a daft question!