With following dataset:
area type result bld1 inspection 1 bld1 inspection 1 bld1 inspection 0 bld1 packing 1 bld1 packing 0 bld1 packing 0 bld1 inspection 1 bld1 packing 0
I would like to visualize a metric in Kibana that will show a multiplication of an average for each type. So we would calculate it like this
Inspection avg: (1 + 1 + 0 + 1)/4 = 0,75
Packing avg: (1 + 0 + 0 + 0)/4 = 0,25
So the metric in Kibana would show 0,75 * 0,25 = 0,1875.
Please note that there might be multiple areas in my index. Also, the number of types can be different depending on area.
I guess that Pipeline Aggregation might handle that but i can't wrap my head around it yet.
I'd appreciate the tips.