2 Replies Latest reply on Aug 16, 2016 11:47 AM by Sarah Arnio

    Finding first order date outside time filters

    Sarah Arnio

      Hi,

      I have created a table which gives me each individual customer who had a purchase in the last 13 weeks and their number of transactions per week. I want to add to this their first order date in the history of our DB. I've tried using a calculated field: MIN([Paid Date]) but it just returns the first order date in the last 13 weeks (given the time filter I've applied). In the example workbook attached, I know this user's first purchase date was in April, but it's showing me June 11 as the first order date. How can I make it give me the April date?

       

      Thanks