@David_Wong Thanks for the explanation.
sum(min(total, [{rule_name}, {event_date}, {channel_id}])) worked on the given example but didn’t work on other data.
here is the sample data where it didn’t work, not sure why.
Expected output
ICD-10 : 93, ICD-9 : 14, FDA Code : 20 total: 127
But, What I got is 86,14,19,119 respectively.
The Sample Data can be found here.