2 Replies Latest reply on Oct 20, 2016 5:30 AM by John Croft

    How to acheive COALESCE function in tableau?

    kamal kumar

      Hi,

      I have this query in my data base(Tera data).

      case WHEN ( (2015 Sales <> 0) AND (COALESCE(2014 Sales,0) = 0 ) ) AND COALESCE(Customer count 14,Customer count 15) IS NOT NULL THEN 'A'

      I want to write this Logic in tableau. Attaching the sample data in excel.

       

       

      Thanks in advance.