6 Replies Latest reply on Jul 17, 2018 10:15 PM by Saharat Sakulsaowapakkul

    Identify newly opened store if its sales on 3 years or earlier is NULL.

    Saharat Sakulsaowapakkul

      Hi Every,

       

      I have store name with its sales in my Tableau workbook.

       

      I am creating new dimension call "Is Newly Opened."

       

      Its logic calculation (In verbal) would be as following.

       

      IF [Sales] in last 3 or earlier is NULL (or 0)

      THEN  "Newly Opened"

      ELSE "Existing"

       

      The created above logic in attached Tableau workbook already.

       

      Above is an example screenshot of my workbook.

       

      The logic "Is Newly Opened" would consider CMR as "Existing"

      but consider CNK as "Newly Opened" since its sales in 2014 is completely NULL

       

      Hope fully someone could revise it into correct formula fit to Tableau accordingly.

       

      Thank you in advance .