Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hello
did you code your set analysis in the expressions of your table ?
can you provide small sample data set on which we can try..
Regards,
try below
max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users))
Regards
Field name is case sensitive, Might be only flag instead Flag ??
max(aggr(sum({<flag = {'Yes'}>}Submission),Users))
Hi,
the max is OK, but you must add too a filter to show field :
if( sum({<Flag = {'Yes'}>}Submission) = max( ......), max(.......),)
regards
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 ?
Try this:
max({<Flag = {'Yes'}>} aggr(sum({<Flag = {'Yes'}>}Submission),Users,Region))
Br,
KC
no its still giving duplicates for users
Could you please what are your dimensions and expressions ?
Or a layout will be helpful.