Need sum Of Value

[errupeshmca (Heyan)]

working on calculating Total sales per day,

I have two column in table to calculate total sales per day based on total shipped that day.
if Total Shipped = 1 and date = today's date.
I need sum of
total dollar value

Any Help Appreciated

[Badger]

Use an aggregate filter.

[Iker (Iker Saint)]

You could create a table visualization, use the filter to get only the products with Total Shipped = 1, and the options for the visualization to get the Total value at the end of the table, otherwise you could use the sum aggregation.

Sum aggregation | Elasticsearch Reference [7.9] | Elastic

[errupeshmca (Heyan)]

Thanks Iker, Using filter i can get the values.