# Visual Builder - Inquiry on Moving Average
**URL:** https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964
**Category:** Kibana
**Created:** [December 1, 2017, 5:09pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964 "2017-12-01T17:09:29Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@ayadirh](https://discuss.elastic.co/u/ayadirh)
#### Post date: [December 1, 2017, 5:09pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/1 "2017-12-01T17:09:29Z")
I am using Time series in Visual Builder.
**In Panel Option** , the time interval is set to auto.
Time Filter is set to "Today" or "Last 15 minutes" in Kibana.
One line chart includes sum aggregation of a field (Eg. Money Count).
I want to overlay 90 days moving average on top of the line chart. So using another series, which includes sum again in parent aggregation and moving average. Here I want to set window for 90 days. Window option in moving average suggests it must be a number. So I think I must define days as the interval in **Panel Option**.
While I define 1d in interval in Panel Option, I am getting Fatal Error: Error: Uncaught TypeError: Cannot read property '0' of undefined
I do not get this error when I select Time Filter in Kibana more than 1 day.
Is there a way to get 90 days moving average when I am viewing Time series when _Time Filter in Kibana_ is _Last 15 minutes_? Am I doing something wrong here?
---
### Author:  [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [December 1, 2017, 10:49pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/2 "2017-12-01T22:49:35Z")
I don't think you can get a 90 day rolling average when you have the time picker set to something less than that.
But if you want to paste a screenshot of what you have I could try it or see if I can come up with an alternate solution.
Regards,
Lee
---
### Author:  [@ayadirh](https://discuss.elastic.co/u/ayadirh)
#### Post date: [December 2, 2017, 2:21pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/3 "2017-12-02T14:21:07Z")
Hi Lee,
Thanks for the reply.
PFA
Regards,
Hridaya S
---
### Author:  [@ayadirh](https://discuss.elastic.co/u/ayadirh)
#### Post date: [December 28, 2017, 9:22am UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/4 "2017-12-28T09:22:42Z")
Hi Lee,
Any Updates?
Regards
---
### Author:  [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [January 3, 2018, 11:07pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/5 "2018-01-03T23:07:44Z")
Hi Hridaya,
Sorry, nothing new to report. You can't get a 90 day rolling average unless your timepicker is set to at least 90 days.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 31, 2018, 11:07pm UTC](https://discuss.elastic.co/t/visual-builder-inquiry-on-moving-average/109964/6 "2018-01-31T23:07:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.