Pre defined filter for Max(value)

mohammada335346

19-11-2018

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.

Predefined Filter.PNG

Accepted Solutions (1)

Accepted Solutions (1)

kapilsharma0101

19-11-2018

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

Answers (0)