How to create a table with cummlative sum and display only final value for given data histogram

[balamurali1 (balamurali)]

Hi ,

I am looking an option how to create a table with cumulative sum displayed over a date histogram but only the final value needs to be displayed

I have used the table visualization and used cumulative sum and used sum bucket of the field with parent as date histogram on time stamp.

However my values are displayed at each day level. I need to get only the final value.

I dont want to use single value visualization as I need to show in table format with two three aggregations and also show the same for previous year.

[dadoonet (David Pilato)]

I'm not sure to understand and a full example could help, but may be you can run a multisearch query with one query filtered on the current year and another on the past year?

Or first use two filter aggs one for past year and another for this year, then do inside the other aggs you need.