Pre defined filter for Max(value)

[mohammada335346]

Hi Team,

I am trying to build one predefined filter for max(value) for each household, same thing I have achieved through QUERY process box, where I am utilising the Aggregate functions and doing group by on Household key. Now when I am trying to achieve the same through predefined filter I am not sure how exactly I can achieve, I am doing something like below but then questions comes for how to do group by.

[Kapil_Sharma_ · Accepted solution]

Hi,

This is not possible in the Predefined filters as per my understanding. As Aggregates functions uses the GroupBy clause which can't be achieved in the PreDefined Filters.

BR,

Kapil