2 Replies Latest reply: Oct 6, 2011 4:18 AM by Dipesh Patel RSS

    exclude one more vaules on condition

    Dipesh Patel

      Hello Expert,

       

      Lets say I have inline data on following format.

      Field1Field2Field3
      3671@1.comOp
      2582@2.comOp
      4523@3.comSe
      3671@1.comOp Ou
      2582@2.comSe
      2582@2.comOp Ou

       

      I am creating straight table chart by using

      Dimension: if(Field3='Op',Field2)

      Expression: count(Field1)

      Result: which are fine based on above conditions.

       

      Field2Count
      1@1.com1
      2@2.com1

       

      But i would like to add another condition to exclude "Op Ou" as well from above result.

       

      Fianl result would be

      2@2.com as it doesn't have any values of "Op" and "Op Ou".

       

      Thanks,

      Dinesh