How to deduplicate and perform aggregations using single Elastic search query?

I have an index where employee details data is stored.

I have feedback field per employee integer values (0-10).

I want to get the count of feedback, avg rating of the feedbacks and avg rating per employee of the feedback.

The problem here is:

So I have two or more same documents (duplicate) in an ES index (using employee id and one feedback identifier, we can distinguish the records),

I want to do avg and count on some fields with only one document to be considered using ES query only

PS: We cannot remove duplications from the index.

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