Aggregation with unique count and sum: how to do it?

Hey @simonlucalandi! I'm not 100% certain if Kibana can produce something exactly like that but I think we can get close...

Can you can create a terms aggregation on your tx_id? Just trying to follow along to this previous issue I found: Sum of unique ids