0 Replies Latest reply on Oct 6, 2017 12:00 PM by Ingrid Moats

    Finding the lifetime value; campaign codes based on a campaign

    Ingrid Moats

      Hi,

      I'm a newbie with Tableau and I'm trying to find the following information.

       

      For Campaign Code = A2

      I'd like to find out all the payments from A2 and thereafter, and the date for the first purchase.  I think I've got the customers and minimum date down, but I'm having trouble with the Paid total.

       

      For example, I have Customer Number 1 with an order on Campaigns: A1, A2, A2, A3 in that order and it will result in 35 total paid amount, but I only want 25 since I'm starting with Campaign A2.

      Additionally, Customer Number 4 only has an order on Campaign C1 so they should not appear in my final results.

       

      I'd like the following results

       

       

      110/2/201725
      28/2/201765
      58/21/201750
      76/5/20170
      86/10/2017

      45

      and

       

       

      1A2A3
      2A2B1B2
      5A2A3A4
      7A2
      8A2

       

       

      Then, how would I deal with this case where the initial campaign can be A2 or A1, so Customer Number 1 would have results A1, A2, A3 and Total Paid Amount of 35?

       

       

      Thanks so much!

      Ingrid