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.