7 Replies Latest reply: Apr 30, 2013 9:55 AM by Ori Tal RSS

    Active Customers in Date Range

    Darren Johnson

      Hello,

       

      I have table of orders and fields 'order date','order reference','customer id'

       

      I need an expression that gives me how many distinct customers (customer id's) have placed an order each day (order date), but have also placed at least one order in the past x number of days...

       

      Can anyone help me out?

       

      Thank you!

       

      Darren