X axis aggregation on line chart

[mikelo (Michele)]

Hi All,

I'm trying to create a scatter plot but I need an aggregation on X-axis. Looks like you can aggregate only on Y-axis.

{"KEY": "K1", "COUNT_1": 1, "COUNT_2": 0, "TIME": "2016-04-08T00:00:00+00:00"}
{"KEY": "K2", "COUNT_1": 1, "COUNT_2": 1, "TIME": "2016-04-08T00:00:00+00:00"}
{"KEY": "K1", "COUNT_1": 1, "COUNT_2": 1, "TIME": "2016-04-09T00:00:00+00:00"}
{"KEY": "K2", "COUNT_1": 1, "COUNT_2": 0, "TIME": "2016-04-09T00:00:00+00:00"}
{"KEY": "K1", "COUNT_1": 1, "COUNT_2": 1, "TIME": "2016-04-10T00:00:00+00:00"}
{"KEY": "K2", "COUNT_1": 1, "COUNT_2": 5, "TIME": "2016-04-10T00:00:00+00:00"}

In the line plot, I want something like

y axis: sum aggregation of COUNT_1 (it works fine!)
x axis: sum aggregation of COUNT_2 (looks like I cannot do it)

I expect a scatter plot with 2 points:
1st point "K1" (x=2,y=3)
2nd point "K2" (x=6,y=3)

Thanks!

[spalger (Spencer Alger)]

I'm pretty sure there isn't any way to do this in Kibana. Aggregations can be used to define the x-axis, but aggregating on the sum of a field requires multiple aggregation stages and I'm pretty sure that none of the Kibana visualizations can accomplish this. Maybe @ppisljar has an idea?

[ppisljar (Peter Pisljar)]

i agree with spalger.