Getting sum of amount of a phone number greater than 50k for specific month


(Nikhil Nambiar) #1

Hi ,
This is my mapping
"mappings":{
"call_list":{
"properties":{
"phone":{
"type":"text"
}
"pretty":{
"type":"text"
}
"amount":{
"type":"long"
}
"name":{
"type":"text"
}
"uts":{
"type":"text"
}

			}
		}
	}

How to write a query to get sum of amount per phone number between the month passed as search value.

for example
If I pass 2018 Oct as a search parameter
I should get output of every phone number in the month of Oct 2018 and its total sum of amount which is within Oct 2018.


(Alexander Reelsen) #2

please do not open duplicates of a thread but answer in the existing one. thanks a lot!


(Alexander Reelsen) #3