Year to date visualization

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?

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

Have you looked into Cumulative Sum aggregation?

1 Like

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?

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.

1 Like

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