# Monthly Year on Year

**URL:** https://discuss.elastic.co/t/monthly-year-on-year/139469
**Category:** Kibana
**Created:** [July 11, 2018, 4:54am UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469 "2018-07-11T04:54:02Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Sunil\_Khullar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunil_khullar/32/50427_2.png) [@Sunil\_Khullar](https://discuss.elastic.co/u/Sunil_Khullar)
#### Post date: [July 11, 2018, 4:54am UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469/1 "2018-07-11T04:54:02Z")

</div>

I need to create monthly aggregation and compare it YoY like below  
 ![monthly-yoy](https://us1.discourse-cdn.com/elastic/original/3X/3/5/35b1c9043526fde9be384c6fb33e320ea68d31ad.jpg)

I did manage it once (by trial and error) but forgot the steps. The older discussions on the topic are not very helpful. I am on 6.2.3

Any help would be welcome.Thanks.

---

<div class="post-metadata">

### Author: ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [July 12, 2018, 4:06am UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469/2 "2018-07-12T04:06:45Z")

</div>

I believe you can do this with Timelion - [here is a blog post](https://www.elastic.co/blog/timelion-tutorial-from-zero-to-hero) with more information that is still relevant. Take a look at "Offsetting data source"

---

<div class="post-metadata">

### Author: ![Sunil\_Khullar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunil_khullar/32/50427_2.png) [@Sunil\_Khullar](https://discuss.elastic.co/u/Sunil_Khullar)
#### Post date: [July 12, 2018, 6:08am UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469/3 "2018-07-12T06:08:21Z")

</div>

Thanks, I was able to get it in timelion. However, I am sure there is a way to do this in normal visualization.

---

<div class="post-metadata">

### Author: ![Sunil\_Khullar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sunil_khullar/32/50427_2.png) [@Sunil\_Khullar](https://discuss.elastic.co/u/Sunil_Khullar)
#### Post date: [July 25, 2018, 1:27pm UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469/4 "2018-07-25T13:27:15Z")

</div>

The timelion also does not provide the solution .  
If I need to compare last 2 years. I need the time scale to show 12 months with years grouped or overlapped for every month.

Timelion shows more than 18 months (if viewed in Jul) and part of the data overlapped.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 22, 2018, 1:29pm UTC](https://discuss.elastic.co/t/monthly-year-on-year/139469/5 "2018-08-22T13:29:02Z")

</div>

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