8 Replies Latest reply: Apr 26, 2018 3:38 PM by Dan Green RSS

    Return two results from IF

    Dan Green

      I have an IF statement as a variable in set analysis. I want it to show both Assigned and Completed items if nothing else in this field is selected but I am unable to figure this out.

       

      This is what I tried:

       

      vHideUnassigned = If(GetSelectedCount(AssignedCompleted) = 0, 'Assigned' and 'Completed', GetFieldSelections(AssignedCompleted))

       

      Measure in Chart:

      Count({<AssignedCompleted={'$(=$(vHideUnassigned))'}>}AssignedCompleted)