1 Reply Latest reply on Jul 6, 2017 6:56 PM by Hari Ankem

    Does not Contain Filter for querying server data

    . Cjhixon

      Hi everyone,

      I'm a Tableau newb so I apologize for asking what has already been asked and answered a few different ways.  The existing answers escape my ability to adapt to my need.  I have SAP work order data that is published to a Tableau Server.  I want to use some filters to reduce the data that is pulled from the server.  I would like to filter on the SAP "SYSTEM STATUS" field.  This field contains several short strings which can be in varied order.  I would like to make my selection on [System Status] Does Not Contain "TECO" or "CLSD".  I'm wondering if there is something I can put into the "Edit Data Source Filters", Condition, By formula field to accomplish this.

       

      [System Status]

      REL CNF NMATPRC SETC

      REL CNF NMATPRC SETC

      TECO CNF NMATPRC SETC

      TECO CNF PRC SETC

       

      Thanks,

      Carl