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.