Pre defined filter for Max(value)

Avatar

Avatar
Validate 1
Level 1
mohammada335346
Level 1

Likes

3 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
mohammada335346
Level 1

Likes

3 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
mohammada335346
Level 1

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)

Avatar

Avatar
Validate 1
Level 3
kapilsharma0101
Level 3

Likes

14 likes

Total Posts

52 posts

Correct reply

18 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 10
Give Back
View profile

Avatar
Validate 1
Level 3
kapilsharma0101
Level 3

Likes

14 likes

Total Posts

52 posts

Correct reply

18 solutions
Top badges earned
Validate 1
Give Back 5
Give Back 3
Give Back 10
Give Back
View profile
kapilsharma0101
Level 3

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)