Year to date visualization

Elastic Stack Kibana
1

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?

2

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

Have you looked into Cumulative Sum aggregation?

3

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?

4

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.