# X axis aggregation on line chart

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!

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 @Nushanth has an idea?

i agree with spalger.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.