Display the sum of a particular field based on other fields

Is it possible to have a first filter that retrieves Unique objects, and then sum a particular field?

Group, ID,Amount
A, 001 ,10
A, 001,10
B,003, 30
C, 004,20
Expected A-> 11,B->30,C->20
How to achieve above in bar chart kibana

You can only do it for all documents, not unique ones sadly. So you could get sum of amount, split by group, but that's about it.

Thanks for your answer. Is there any option in kibana 7

You could probably do it in Canvas using ESSQL.

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