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!