Expand my Community achievements bar.

SOLVED

Pre defined filter for Max(value)

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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