Kibana Visualizing Array fields in Dashboards

Elastic Stack Kibana
1

Hi I have created an array for family details.

filter {
mutate {
add_field => {"employee.family"=>"%{familyMember}"}
}
}

So in here employee.family =["mom", "son", "daughter"]

I created Visualisation on how many employees have sons, daughters etc.

But when i filter the dashboard employee.family:"son" it shows mom,father also.

This is because employees have both son and mother in array. But I need to show son value in dashboard.

Need a solution on this.

2

Which kind of visualization you want? Sharing the current visualization and the picture of what you want.
Most visualization can visualize terms count, which is the number of employees who have sons.

If you want to aggregate the number of "son" (one employee have multiple "son"s in the array), it is a bit complicated and you need script.