3 Replies Latest reply: Aug 29, 2017 1:10 PM by Anand Chouhan RSS

    Include into set

    sony sing

      Hi all,

      Anand Chouhan

      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)