# Moving Average Visualization
**URL:** https://discuss.elastic.co/t/moving-average-visualization/217793
**Category:** Kibana
**Created:** [February 4, 2020, 11:41am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793 "2020-02-04T11:41:50Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Rizin\_Hussain](https://discuss.elastic.co/u/Rizin_Hussain)
#### Post date: [February 4, 2020, 11:41am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/1 "2020-02-04T11:41:50Z")
Hi,
I have been working in Elasticsearch and Kibana since few months, I got a requirement to build a Moving Average visualization with Time data. when I had tried create the same, facing some difficulties,
I need to create a visualization by showing 10 days moving average with Date and Time data. Kindly anyone can help me out here
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [February 4, 2020, 6:48pm UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/2 "2020-02-04T18:48:55Z")
Hi @Rizin_Hussain. The [TSVB visualization](https://www.elastic.co/guide/en/kibana/current/TSVB.html) supports Moving Average aggregations.
Example:
---
### Author:  [@Rizin\_Hussain](https://discuss.elastic.co/u/Rizin_Hussain)
#### Post date: [February 5, 2020, 4:18am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/3 "2020-02-05T04:18:24Z")
Thanks nick !!! I have few more confusions, Kindly clarify
When you say Moving average can be achieved using Time Series Visualization, Is this mandatory to configure that particular field(time representation field) as a timestamp while creating the Index Pattern?
I have found during my investigation, there is a aggregation method as 'Moving Average' in the Line type visualization, but did not able to find the way to specify the window size. Kindly guide me through.
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [February 6, 2020, 1:19am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/4 "2020-02-06T01:19:39Z")
Hi @Rizin_Hussain. Yes, it also possible to do a Moving Average with the line visualization. I think what you will want to do is add a Date Histogram bucket on the X-Axis which will allow you to specify the window size as a "Minimum Interval".
---
### Author:  [@Rizin\_Hussain](https://discuss.elastic.co/u/Rizin_Hussain)
#### Post date: [February 6, 2020, 7:08am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/5 "2020-02-06T07:08:04Z")
I have tried to do the same, but did not find any field to specify the Window Size. attached screenshot.
---
### Author:  [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [February 6, 2020, 4:35pm UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/6 "2020-02-06T16:35:53Z")
Hi @Rizin_Hussain. My apologies, I misunderstood the question. It seems the only way to change the default window size (5) is by customizing the JSON Input for the Y Axis as mentioned in this [issue](https://github.com/elastic/kibana/issues/10734).
I have tested this in 7.5.2 and it appears to work.
---
### Author:  [@Rizin\_Hussain](https://discuss.elastic.co/u/Rizin_Hussain)
#### Post date: [February 7, 2020, 5:20am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/7 "2020-02-07T05:20:14Z")
ok, Thanks nick !!! Got your answer.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 6, 2020, 5:20am UTC](https://discuss.elastic.co/t/moving-average-visualization/217793/8 "2020-03-06T05:20:19Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.