How can i apply filter or another query on the value calculated in es query

Elastic Stack Elasticsearch
1

GET urza/user/_search
{
"script_fields": {
"my_score": {
"script": "doc['total_revenue_i'].value / doc['purchased_i'].value"
}
},"query": {
"range": {
"total_revenue_i": {
"gt":0
}
}
}
}

how can i apply filter on my_score value that will be calculated in above query

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.