I am trying to move away from excel into ES+Kibana. I have some data (lets say, the name, age, IQ and height of 10000 people) that can be histogram-ed (lets say over the the IQ field with a bin size of 10). I wish to plot a linear trendline of this data. How can I do it?
I tried using Moving Average (Parent Pipeline Aggregation) and it works, except that I cannot seem to set a window size for the moving average (the default appears to be 2 samples) which is supported by ES according to the documentation.
How do I plot a linear trendline (no prediction needed, just over the existing data) using Kibana?
Or if thats not possible, a moving average with a custom window-size?
Thanks in advance.