I want to get sum of latest value of a field . With several conditions which is applied over other fields. I am working on time series data and want to get information from last poled value. Example Data:- A B C q1 1 2343 q1 2 53 q1 3 -1 q1 4 -1 q2 1 -1 q2 2 435 q2 3 543 q2 …

Thanks @Ignacio_Vera for replying.

Strictly based on what you provided I ran a quick test (unless I misunderstood) PUT /sunman/_mapping { "properties": { "a": { "type": "keyword" }, "b": { "type": "integer" }, "c": { "type": "integer" } } } and then i added your do…

Thanks @Sunile_Manjee . I tried over my code and it worked. Instead doing like this I was looking other way round. It helped a lot. :slightly_smiling_face:

@Sunile_Manjee but still one issue is there. I am getting the result but my data is time series data. I want only last pole to be taken into consideration to perform aggregation. It's changing if I change time interval.

@Fiza please provide me an example of the output you are expecting based on the inputs you provided earlier.

A B C q1 1 2343 q1 2 53 q1 3 -1 q1 4 -1 q2 1 -1 q2 2 435 q2 3 543 q2 4 -1 Suppose this is the data received from the last pole @timestamp A. There are also previous data (of same format) which I am storing in my database. (Like at timestamp A-2m, A-4m etc). Example of Data…

Can we use sub aggregation after top metric aggregation

Elastic Stack Elasticsearch

Ignacio_Vera (Ignacio Vera) April 28, 2023, 10:53am 2

You cannot have a sub-aggregations under a top metrics aggregation. It is a bug that you don't get an error in this case, i have opened: top_hits aggregation should fail if it contains sub aggregations · Issue #95663 · elastic/elasticsearch · GitHub

Topic		Replies	Views
Sub aggregating top_hits Elasticsearch	7	482	February 20, 2024
How to get the last nested object of all documents then perform sub-aggregations Elasticsearch	3	1020	December 11, 2019
Double Terms aggregation with top_hits sub-aggregation not working Elasticsearch	5	102	January 9, 2025
SUM top hit aggegration? Elasticsearch	4	3175	November 27, 2018
Subselect filter for aggragation Elasticsearch	3	268	June 29, 2022

Can we use sub aggregation after top metric aggregation

Related topics