# Year to date visualization

**URL:** https://discuss.elastic.co/t/year-to-date-visualization/353539
**Category:** Kibana
**Created:** [February 19, 2024, 5:17am UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539 "2024-02-19T05:17:57Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Senol\_Kurt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/senol_kurt/32/113382_2.png) [@Senol\_Kurt](https://discuss.elastic.co/u/Senol_Kurt)
#### Post date: [February 19, 2024, 5:17am UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539/1 "2024-02-19T05:17:57Z")

</div>

i have an index that holds monthly aggregated sales data. i want to visualize year to date sales for each month. can i do it without creating a new field and what is the best way to do it?

---

<div class="post-metadata">

### Author: ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)
#### Post date: [February 19, 2024, 8:11pm UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539/2 "2024-02-19T20:11:51Z")

</div>

Hi Senol, are you using this visualization in Kibana, or in DevTools?

Have you looked into Cumulative Sum aggregation?

> **[Cumulative sum aggregation | Elasticsearch Guide \[8.12\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-cumulative-sum-aggregation.html)**

---

<div class="post-metadata">

### Author: ![Senol\_Kurt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/senol_kurt/32/113382_2.png) [@Senol\_Kurt](https://discuss.elastic.co/u/Senol_Kurt)
#### Post date: [February 20, 2024, 5:01am UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539/3 "2024-02-20T05:01:57Z")

</div>

i want to visualize it in Kibana and want to compare year to date values of each year. i tried cumulative sum but couldn't figure out how to compare each year?

---

<div class="post-metadata">

### Author: ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)
#### Post date: [February 20, 2024, 12:41pm UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539/4 "2024-02-20T12:41:15Z")

</div>

I think it might be interesting for us to better understand how to help if you provide an index mappings example and the result you expect to achieve after the query.

---

<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: [March 19, 2024, 12:41pm UTC](https://discuss.elastic.co/t/year-to-date-visualization/353539/5 "2024-03-19T12:41:29Z")

</div>

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