Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Pre defined filter for Max(value)

mohammada335346
Level 2
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
kapilsharma0101
Correct answer by
Level 4
Level 4

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
kapilsharma0101
Correct answer by
Level 4
Level 4

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