Include into set

[soniasweety]

Hi all,

I have a expression in dimension am using  like below

=if(Task_Days>=limit, ID) 

so I just want to include the some other condition  how can I do this?  can anyone give idea?

there is a field  assigned   in that I have 10 values  like  a,b,c,d,e.......  so on  but I want to  display only    a,b,c  only

=if(Task_Days>=limit, ID)

how can I incorporate with above expression?

tried below not working

=aggr(only({<Assigned={'a','b','c'}>}ID) if(Task_Days>=limit, ID),ID)

[tresesco · Accepted solution]

Try like:

=if(Match(Assigned, 'a','b','c') and Task_Days>=limit, ID)

[its_anandrjs]

Rather then using this expression why not you using this expression on the Expression not on dimension.

Ex:-

Sum( {<Assigned = { 'a','b','c' }, Task_Days = { ">=$(limit)" } >}  YourMetricFieldHere )

[sunny_talwar]

May be create a flag in the script

If(Task_Days >= limit, 1, 0) as Flag and then use like this

=Aggr(Only({<Assigned={'a','b','c'}, Flag = {1}>} ID),ID)

or

=If(Flag = 1 and Match(Assigned, 'a', 'b', 'c'), ID)

[soniasweety]

thanks all its working fine