Is it possible to apply a filter on a metric aggregation in Kibana using the data set below?
I would like to report on
- Count (10)
- Average (30.43) - which is the sum of the ages divided by 7 (i.e. excluding the empty/zero age attributes).
Is there anyway to provide the filters in the settings?