4 Replies Latest reply on Oct 21, 2018 1:05 PM by Phil Ju

    Creating One Dimension with Multiple Calculated Measures

    Phil Ju

      Hello,

       

      I have a data set that looks like the following. Each row represents a unique lead, which week they signed up, and any subsequent dates of events after signup (events 1 and 2).

       

      LeadSignup week
      Event 1
      Event 2
      A1MarApr
      B2
      C2AprJul
      D3Jan
      E4
      F4Oct

       

       

      I would like to achieve the following view. I would like to create a new calculated field called "Conversion" where it calculates the conversion rates from Signup --> Event 1 and then Event 1 --> Event 2, through the lens of each Signup week.

       

      For example:

      • In Signup week 1, 100% of the Signups converted to Event 1, and 100% of Event 1s converted to Event 2
      • In Signup week 2, 50% of the Signups converted to Event 1, and 100% of Event 1s converted to Event 2
      • In Signup week 3, 100% of the Signups converted to Event 1, and 0% of Event 1s converted to Event 2
      • In Signup week 4, 50% of the Signups converted to Event 1, and 0% of Event 1s converted to Event 2

       

       

      Conversion

      Signup week

      1

      Signup week

      2

      Signup week

      3

      Signup week

      4

      Event 1 Conversion100%50%100%50%
      Event 2 Conversion100%100%

       

      Thank you!