Hi shaunak,
Thank you for your interest.
I'm using the last version (5.1.1) of Elasticsearch, Kibana et Logstash.
Here is the result of the Request tab :
{
"size": 0,
"query": {
"bool": {
"must": [
{
"query_string": {
"query": "*",
"analyze_wildcard": true
}
},
{
"range": {
"dernier update": {
"gte": 1467323564738,
"lte": 1483138364738,
"format": "epoch_millis"
}
}
}
],
"must_not": []
}
},
"_source": {
"excludes": []
},
"aggs": {
"2": {
"date_histogram": {
"field": "creation",
"interval": "1M",
"time_zone": "Europe/Paris",
"min_doc_count": 1
}
}
}
}
And for the Response tab :
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 719,
"max_score": 0,
"hits": []
},
"aggregations": {
"2": {
"buckets": [
{
"key_as_string": "2015-03-01T00:00:00.000+01:00",
"key": 1425164400000,
"doc_count": 1
},
{
"key_as_string": "2016-02-01T00:00:00.000+01:00",
"key": 1454281200000,
"doc_count": 1
},
{
"key_as_string": "2016-04-01T00:00:00.000+02:00",
"key": 1459461600000,
"doc_count": 5
},
{
"key_as_string": "2016-05-01T00:00:00.000+02:00",
"key": 1462053600000,
"doc_count": 6
},
{
"key_as_string": "2016-06-01T00:00:00.000+02:00",
"key": 1464732000000,
"doc_count": 30
},
{
"key_as_string": "2016-07-01T00:00:00.000+02:00",
"key": 1467324000000,
"doc_count": 88
},
{
"key_as_string": "2016-08-01T00:00:00.000+02:00",
"key": 1470002400000,
"doc_count": 85
},
{
"key_as_string": "2016-09-01T00:00:00.000+02:00",
"key": 1472680800000,
"doc_count": 151
},
{
"key_as_string": "2016-10-01T00:00:00.000+02:00",
"key": 1475272800000,
"doc_count": 129
},
{
"key_as_string": "2016-11-01T00:00:00.000+01:00",
"key": 1477954800000,
"doc_count": 114
},
{
"key_as_string": "2016-12-01T00:00:00.000+01:00",
"key": 1480546800000,
"doc_count": 109
}
]
}
},
"status": 200
}
There is too many response... I asked a graph for the last 6 months.
Values from the 6 last months seem to be good, but older are not "normal" values (I have to check that, but less that 10 is not a normal result.