Get the good count in the char pie

[radi]

Hello, i want get the count of value "Ok" and "NO" in fields checkmembers
this is my data :

"_index": "index",
"_type": "members",
"_id": "252410",
"_score": 1,
"fields": {
"checkmembers": [
"ok",
"ok",
"No"
]
}

This is what i use in visulalize , i used char pie :
Slice Size
Aggregation count

Split Slices
Aggregation
Field checkmembers
Order By metric: count

The résult count 1 ok and 1 No

it's not the result i need !
"checkmembers": [
"ok",
"ok",
"No"
]
the result i need it's 2 ok and 1 No

There is solution to get this result?

Thank's

[thomasneirynck]

hi @radi,

The aggregations in Kibana don't work on nested objects, in this case checkmembers. cf. https://www.elastic.co/guide/en/kibana/current/nested-objects.html. This is an outstanding feature request https://github.com/elastic/kibana/issues/1084.