New histogram's chart value: "weighted mean"

[Benoit-DunandLaisin]

Hi there.

I would need to add a new chart value in histogram: "weighted mean".
That would draws a more precised mean graph than with a chart value set to "mean".

That graph needs two input values instead of only one: "sum" and "count".

Let me explain the need with this example:

My data:

timestamp | Id | Type       | mean | count | sum
10:00     | 1  | Aggregated |  10  |   2   |  20
10:02     | 2  | Aggregated |  12  |   3   |  36
10:05     | 3  | Aggregated |  11.5|   4   |  46
10:06     | 4  | Aggregated |  2   |   1   |  2
10:09     | 5  | Aggregated |  10.8|   8   | 86.4

A 5 minutes interval chart (weighted mean) on "sum"/"count" values would generate this plots serie:

timestamp | weighted mean | Comments
10:00     |     10        | Id=1 so value is 20/2
10:05     |     11.71     | Id=2+3 so value is (36+46)/(3+4)
10:10     |     9.22      | Id=4+5 so value is (2+86.4)/(1+8)

You can compare with the result of a 5 minutes interval chart (mean) on "mean" value:

timestamp | weighted mean | Comments
10:00     |     10        | Id=1 so value is 10/1
10:05     |     11.75     | Id=2+3 so value is (12+11.5)/2
10:10     |     6.4       | Id=4+5 so value is (2+10.8)/2

For implementation, that would use 2 facets:

• one for "sum" values
• one for "count" values
  And then, for each "sum" facet results, kibana divides the total of "sum" by the total of "count".

Do you think I'm thinking right?

Regards,
Benoit

[analytically]

👍

[rashidkpc]

We have decided to set a policy of not modifying numeric values client side in Kibana 4. The elasticsearch team is looking into ways of accomplishing this on the server side. Once that work gathers some steam we will work on integrating it into Kibana 4.

[baselsalam]

+1.

[michaelluk6]

+1