I’m trying to do an aggregation of a filter that shows me the Sum of a Max value of a field.
I’ve got 6 log messages.
Those messages have 3 differents IDs (id1, id2 and id3) with multiples values like this table:
I need to get the max(Col2) by Col1 and later do a Sum of those max(Col2)
Somenthing like Sum(Max(Col2)) of Col1.
Does anyone have any ideas?