[influxdb] Does InfluxDB fit the time range values use case?

[n***@gmail.com]

Hi,

We are considering to use InfluxDB to store values that are actually an average value for a given time range.

In the documentation, I did not find a way to store a value with a time range instead of a timestamp.

We have several devices that give us a value that average several measurements taken between t1/t2 (the duration can vary according to the device types) so when we create buckets of one hour, we would like to weight the values according to the time span that overlaps the bucket. In other words, if a value is taken between 01:50 and 02:05 we would like it to be weighted of 0.66 for the 01:00 bucket and of 0.33 for the 02:00 one.

Also, our measures are taken at a specific position and we would like to query our values for a given geographic area so what is the best in this case, using tags with geohashes and make WHERE queries with regexps or are there something better to do ?

Thanks for your help.