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