I wanted to write code inside scripted_fields in kibana

Elastic Stack Kibana
1

I wanted to have a ratio of sum of the document when its suggestion is auto (doc['driverSuggestion'].value== 'AUTO') to divide it by sum of the document when its suggestion is auto plus manual. sum(doc['driverSuggestion'].value== 'AUTO')/(sum(doc['driverSuggestion'].value== 'AUTO')+sum(doc['driverSuggestion'].value== 'MANUAL'))

How to do it?

2

Can you provide an example document? I do not really understand what numbers are trying to sum.

3

{
"driverSuggestion": "MANUAL",
"expiryDriverIds": [
"only1curtis5@gmail.com",
"pdburbanks5@gmail.com"]
}

4

I don't see anything that can be summed in this document. Are you trying to count the items in the expiryDriverIds array?

5

previous issue got resolved can you help with this one?