Assume that i have personal details (names / adderess / phones / age and etc) of city people
I need to build Table Visualization in Kibana 7 based on those details.
The visualization should display the following fields :
The issue is related to the last coulm : "Average age over 13"
CityName | Total population | Avg age over 13 year ======================================= New Yoark | 19,000,000 | 28 Paris | 10,000,000 | 36
Step I have took :
--Metric --> Aggregation : count
Buckets --> split rows --> terms --> Field:CityName Order by Count
Now i have added second metric :
--Metric -->Aggregation:Average , Field : AGE , Order by Count
The above steps shows the population of each city and it avg. population age.
I need to display the avevarge age ABOVE 13 year .