Allow average on boolean

[champtar]

Hi,

Kibana currently only accept to use avg on numbers, but it can also make sense on boolean:
I have an is_hit boolean in my index/mapping, avg of is_hit is my hit ratio (false = 0, true = 1)
Elasticsearch already support this, just need to lift the restriction in Kibana

for now as an ugly workaround i'm using a scripted field

return doc['is_hit'].value ? 1 : 0;

Regards
Etienne

[champtar]

This allow average on boolean, but it need way more love for correct formating (in percent for exemple)

--- a/src/ui/public/agg_types/metrics/avg.js
+++ b/src/ui/public/agg_types/metrics/avg.js
@@ -12,7 +12,7 @@ export default function AggTypeMetricAvgProvider(Private) {
     params: [
       {
         name: 'field',
-        filterFieldTypes: 'number'
+        filterFieldTypes: 'number,boolean'
       }
     ]
   });

[timductive]

Closing this because it's not planned to be resolved in the foreseeable future. It will be tracked in our Icebox and will be re-opened if our priorities change. Feel free to re-open if you think it should be melted sooner.