4 Replies Latest reply: Dec 1, 2017 8:04 AM by snehal nabar RSS

    How to add a sort of "WHERE" clause filter?

    Adam Tate

      HI all,

       

      I have added a table to my dashboard, is there a simple way of adding a "where" type clause such as

       

      "Salesperson = "Adam" OR SalesPerson = "bob"?

       

      I am playing around with the expression editor but cannot find the correct syntax. If I use Salesperson = "Adam" it will filter the result down correctly but the label on the row that that given field will be changed to "0" & "1".


      Thanks in advance