Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try like:
=if(Match(Assigned, 'a','b','c') and Task_Days>=limit, ID)
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 )
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)
thanks all its working fine