Hello Sean,
Thank you for the quick response and I am sorry for the typo. I
figured out the solution for that now everything fine, I am getting results
what I am expected.
Below are the actual records that i have in influxDB
2015-01-01T00:00:00Z 6
2015-01-01T00:15:00Z 11
2015-01-01T00:30:00Z 18
2015-01-01T00:45:00Z 27
2015-01-01T01:00:00Z 32
2015-01-01T01:15:00Z 38
2015-01-01T01:30:00Z 45
2015-01-01T01:45:00Z 52
2015-01-01T02:00:00Z 60
2015-01-01T02:15:00Z 66
2015-01-01T02:30:00Z 76
2015-01-01T02:45:00Z 86
2015-01-01T03:00:00Z 95
2015-01-01T03:15:00Z 103
2015-01-01T03:30:00Z 110
2015-01-01T03:45:00Z 116
2015-01-01T04:00:00Z 125
*Query:*
*select spread(consumption_count) from TestMeterData where time >=
'2015-01-01 00:00:00' and time <= '2015-01-01 04:00:00' and meter_id='1'
group by time(1h)*
when i run above query i got fallowing records as output
2015-01-01T00:00:00Z 21
2015-01-01T01:00:00Z 20
2015-01-01T02:00:00Z 26
2015-01-01T03:00:00Z 21
2015-01-01T04:00:00Z 0
Now here is my problem, I am storing data in for every 15 mins time
interval, But when I get the results last 15 mins data of every hour was
missing. I have figured out solution with another method, But why it is not
happening with *Spread* function?
Thank you.
On Fri, Jun 17, 2016 at 2:02 AM, Sean Beckett <[email protected]> wrote:
> 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 a topic in the
> Google Groups "InfluxDB" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/influxdb/TZgglmSro5A/unsubscribe.
> To unsubscribe from this group and all its topics, 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
> <https://groups.google.com/d/msgid/influxdb/CALGqCvMdieABqm7CScMRCAaq9JyWMRG5JzAB3w31Tj0yyY_hrw%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
--
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/CAEvTO9wg-aAmOkjvkP257qBmVhoQPKqVYHdAPiO6oaTLOXmPRA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
