Hi,
When doing a group by over time, is it possible to get the number of distinct
values in the time dimension in each group. The scenario is as follows:
Time Value
2016-12-10T00:00:00 1
2016-12-10T00:00:01 1
2016-12-10T00:00:01 1
2016-12-10T00:00:02 1
2016-12-10T00:00:02 1
2016-12-10T00:00:04 1
2016-12-10T00:00:08 1
Given this data I would like to be able to group the data over a time window
and get the number of distinct times in each group. So for a 2min window and
the data above it should give me the following:
Time/Group "Distinct Times"
2016-12-10T00:00:00 2
2016-12-10T00:00:02 1
2016-12-10T00:00:04 1
2016-12-10T00:00:08 1
Since the data contains values for both 2016-12-10T00:00:00 and
2016-12-10T00:00:01 which both falls into group 2016-12-10T00:00:00 etc.
I have tried to just do a SELECT Distinct("Time") ... but that does not work. I
could propably just add a time field and do a distinct on that but that seems
redundant.
Is such a construct possible?
--
Remember to include the version number!
---
You received this message because you are subscribed to the Google Groups
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit
https://groups.google.com/d/msgid/influxdb/ae95125a-fc8b-4150-8297-4ba29583eecc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
