11 Replies Latest reply on Oct 18, 2013 5:06 AM by Matt Lutton

    Trying to create a calculated field returning the previous days value from another column

    Michael McCarthy

      i am trying to calculate the 1 day click through rate on emails sent. Attached is a packaged workbook of what i am trying to do.

       

      There are two dates here: traceday and senddate. I am looking to return the [Distinct Emails] value where the two date values equal. so what is actually happening is traceday is the day someone visits and senddate is the day the email was sent originally. i will then use the send rate for that day and find my CTR. I am having trouble with getting the value for [Distinct Emails] for the send date the same as traceday.

       

      Any help would be much appreciated!

       

      Thanks

      Michael