Hey guys, I’ve got a question.
I'm working with an event that has two properties: propertyA and propertyB. What I want is to get the maximum value of propertyB for each propertyA.
When I use Aggregate Property -> Maximum -> propertyB and then add a breakdown by propertyA, I end up seeing duplicate rows for the same propertyA.
Is there a way to make the results show only distinct propertyA values with their corresponding maximum propertyB?