5 Replies Latest reply on Mar 6, 2017 1:04 AM by Marco R

    Filter and analize(2)

    Marco R

      I'm new in Tableu...one question: how can I translate in tableau the SQL query below?

       

      In SQL-like:

       

      select diagnosis,count(distinct patient)

      from patientdiagnosis_table

      where diagnosis<>'A' and patient in

      (

      select patient from patientdiagnosis_table where diagnosis='A'

      )

      Group by diagnosis

       

      Thanks in advance.