Hello Druid Gurus,
Does Druid have the capability to apply MAX on a string column?
Basically I am writing a Druid query to return the max of a flag (Y/N). Along with that, i also want to agrgegate a metric (across all dimensions).
I checked the group and there was a note on TopN last year. This worked, but the metric (usd_amount) value returned is only for the top flag. Below is some sample data and expected results.
The expected result is
Is this possible ?