Set analysis with Max Function

[Anonymous]

Hi All,

I have a requirement where in I have to show users with maximum submission count and the table to show only with flag  = yes

I had written the following expression : this is working fine for max submission based on users but the flag = yes isn't working(the table is showing flag = no as well):

max(aggr(sum({<Flag = {'Yes'}>}Submission),Users))

Any help will be much appreciated.

Kindly let me know if the requirement is unclear

Thanks,

Anupama Jagan

[olivierrobin]

hello

did you code your set analysis in the expressions of your table ?

[PrashantSangle]

can you provide small sample data set on which we can try..

Regards,

[PrashantSangle]

try below

max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users))

Regards

[Anil_Babu_Samineni]

Field name is case sensitive, Might be only flag instead Flag ??

max(aggr(sum({<flag = {'Yes'}>}Submission),Users))

[ogautier62]

Hi,

the max is OK, but you must add too a filter to show field :

if( sum({<Flag = {'Yes'}>}Submission) = max( ......), max(.......),)

regards

[Anonymous]

this works perfect. But when I add region to the table i'm getting multiple values for the users. Because for same two regions that user has max num of submissions. Is there  any way to get the first instance of it ?

[jyothish8807]

Try this:

max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users,Region))

Br,

KC

[Anonymous]

no its still giving duplicates for users

[jyothish8807]

Could you please what are your dimensions and expressions ?

Or a layout will be helpful.