Please provide some actual query input and output. Your retyped example has a typo (time before 7 p.m. and later than 11 p.m. of the same day) and I'm not sure what else might be off.
On Tue, Jun 14, 2016 at 1:09 AM, <[email protected]> wrote: > *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 > <https://groups.google.com/d/msgid/influxdb/ba13aaed-aadf-4def-9575-f7358300ec1c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvMdieABqm7CScMRCAaq9JyWMRG5JzAB3w31Tj0yyY_hrw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
