I have an index storing family data. One of the properties is "childrenAges" which stores a list of the ages of the children in the family, see sample data below.
I need to be able to count the ages of children across the index, so using the test data below I need to see...
Aged 1 = 1
Aged 5 = 1
Aged 6 = 3
Aged 10 = 3
I can't find a way to count values by this repeating group. Is it possible to do this?
PUT test-family-data
{
"mappings": {
"properties": {
"name": {
"type": "keyword"
},
"childrenAges": {
"type": "integer"
}
}
}
}
POST test-family-data/_doc
{
"name": "Smith",
"childrenAges": [5,6,10, 10]
}
POST test-family-data/_doc
{
"name": "Jones",
"childrenAges": [1,6, 6, 10]
}