Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Creating a calculated column from another table based on date criteria

Example file with Sales and Mailers Tables Example End Product Conversion Chart by Campaign Background: We help boat dealers sell boats, we do marketing for them. I have 2 tables: Mailer table ...
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous quick question, I think you want to get the campaign id based on store / customer, not only just dealdate

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi parry2k  - Yes, you are right, sorry for the confusion!

     

    Basically the last Campaign the customer received before they actually bought a boat, based on those date criterias.

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous how about store? Does that matter? I noticed campaigns are by store

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        parry2k Store is important because we send campaigns on behalf of a store, but it's really which campaign triggered the customer to buy.

         

        Then I can show which campaigns are performing well for individual stores.

         

        Thank you so much for your help on this!

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      We can send the same type of campaign to multiple stores

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I reviewed this post when I was researching my problem but I think it is off point.  I have a string of tables that are related to one another Booking => Order => Division.  I am trying to create a calculated column in my Booking table based on something in my Division table.  I beleive I need to create two related statements with the lookupvalue statement but am not sure how to do this.