Display the sum of a particular field based on other fields

Elastic Stack Kibana
1

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

E.g.:
Group, ID,Amount
A, 001 ,10
A, 001,10
A,002,1
B,003, 30
C, 004,20
Expected A-> 11,B->30,C->20
How to achieve above in bar chart kibana
Thanks

2

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.

3

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

4

You could probably do it in Canvas using ESSQL.