2 Replies Latest reply on Sep 13, 2018 3:39 PM by Raoul Verhaegen

    Flag customers who made a transaction in a range of dates

    Raoul Verhaegen

      Hi,

       

      I need to flagcustomers who made a transaction in 2014. It doesn't matter if it's their first or their 666th. Of course, Tableau won't let me do it because there's different levels of aggregation

      {FIXED [Customer Name]: IF [Order Date]>= date("2014-01-01") AND [Order Date]<=date("2014-12-31") THEN 'yes' END}

       

      Anyone got an idea to fix this?

       

      Thanks