How to set window size for moving average?

Elastic Stack Kibana
1

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.

tl-dr:
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.

2

Hello,

  1. Trendlines are not available in Kibana yet. There is an enhancement request for this that you can track: https://github.com/elastic/kibana/issues/3325
  2. As far as I know, setting the window size for moving is always set as 2 samples. It would be nice if you could add an issue/enhancement request in GH so that we could decide when to put it on the roadmap. And more information about the use case usually helps in having them picked up by the dev team.
3

Thanks, Marius.
I created a issue at https://github.com/elastic/kibana/issues/13836

Misc note: Coming in from Excel - with an eye towards collaborative studies on data thats too large to really email around to people and sharing of data/insights - I'm hoping the ES+Kibana is a replacement for both Excel's features and has Tableau's accessibility.

1 Like
4

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