*Hello Everyone,* * I am storing data for every 15 minutes in influx database. When I wrote a query to get data using spread and grouping by one hour. Every time i am losing last 15 minutes data.*
*Below is my query* *select consumption count from testData where time < = '* *2016-06-12T19:00:00Z'** and time >= '**2016-06-12T23:00:00Z**'* what i need to do to get last 15 mins data. Example: consider i have data like below *2016-06-12T19:00:00Z -> 15* *2016-06-12T19:15:00Z -> 22* *2016-06-12T19:30:00Z -> 28* *2016-06-12T19:45:00Z -> 32* *2016-06-12T20:00:00Z -> 36* *When i run above query with above time intervals i am getting spread value 17 which is 32-15 instead of this i need to get 21 which is 36-15. which causes me losing last 15 minutes data. * *Anyone, please help on this.* *Thankyou in advance* -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" 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/ba13aaed-aadf-4def-9575-f7358300ec1c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
