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

    Something like a "Not Exists" SQL function

    Gustavo Quintilhano



      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))