Below I have put my filters aggregation query. But it is giving me invalid result on filtering for a single day using gte/lte
Ex. If I use get and lte as 02/03/2016 and 05/03/2016 it gives me correct summary as 5527915. The actual break up of 2,3,4,5 is 1882846,1848504, 1794313 and 2252
But, if I use 02/02/2016 for gte and 02/02/2016 for let, it gives me 3636. A complete wrong result. My goal is to get the count for single day and I"m not able to achieve it. Any guidance please
{
"size": 0,
"aggs": {
"CustomGroups": {
"filters": {
"filters": {
"Test1": {
"bool": {
"filter": [
{
"range": {
"PublishedTimeGMT": {"gte":"02/03/2016","lte":"02/03/2016","format":"dd/MM/yyyy"}
}
}
]
}
}
}
}
}
}
}