How to calculate % growth for a sliding time window with a yearly offset?

Elastic Stack Kibana
1

I would like to create a timelion visualizaiton which shows a % growth of received documents within a range of 1 week against the same week but a year ago. I am not sure if the below timelion expression does exactly that.

.es(index=received_docs, timefield=created_at, q='status:uploaded').mvavg(window=7d)
.divide(.es(index=received_docs, timefield=created_at, q='status:uploaded', offset=-1y).mvavg(window=7d))
.subtract(1)

Is there a visualization that can show just the growth numbers?
Maybe using .derivative() is a better solution to show growth?

2

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