3 Replies Latest reply on Aug 20, 2014 5:54 AM by Avia Makky

    Count within If Statement

    Avia Makky

      Hi All,

       

      I am new to Tableau and this is the first day I am working on this tool.

       

      I am working on the Sample data provided with Tableau Desktop Installation i.e Super Store Sales Excel file.

       

      I have created the left join between the Orders tab Returns table.

       

      Now I Wish to create a calculated filed as "Orders Returned" and the logic I need to apply is as follows:

      Count(Order ID) >>This order ID is from Orders Tables

      IF (Status='Returned') >> Status is a field in Returns table.

       

      I am not able to find the proper syntax for the same.

       

      Thanks in Advance.