Applying filters on a metric using Visual Builder

[kenneth]

Hi,

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?

Regards
Kenneth

[chrisronline (Chris Roberson)]

Hey @kenneth,

You should be able to apply a filter at the top for something like this.

Let me know if that helps,

Thanks,
Chris