1 Reply Latest reply on May 26, 2015 10:55 AM by Rody Zakovich

    Something like a "Not Exists" SQL function

    Gustavo Quintilhano

      Hello,

       

      I Need to filter some data finding a ID field in other column, something like a not exist sql function. I have that sql query but, don't now how to convert in Tableau calculation.

       

      SQL Query:

       

      select [numero de registros] from ticket_principal tp where not exists (select 1 from ticket_principal where tipo = 'INCIDENT' and origem_id = tp.id and month(origem_dt_criacao) = month(tp.data_abertura))


      Thanks