Elasticsearch Hour data

[rapolu_vinod (elas)]

Hi All,

how do i get specific hour data of last 30 days from elasticsearch query.

Kindly help me. Thanks in Advacne.

[magnusbaeck (Magnus Bäck)]

Add a range condition on your timestamp field to your query.

[rapolu_vinod (elas)]

hi magnusbaeck,

I need Every day count of that specific hour .

Ex: 2016-11-05 -- 01 hr count 25
2016-11-06-- 01 hr count 30
........................

[magnusbaeck (Magnus Bäck)]

Oh, that's something completely different. Then you need a date histogram aggregation.

[rapolu_vinod (elas)]

Ok, Thank you,

Is there any way of doing aggregations on data histogram..

for example 2016-11-05 -- 01 hr count 25
2016-11-06-- 01 hr count 30

 So avg count of specific 01 hr is  (25+30)/2-----55/2=25.25

is it possible