6 Replies Latest reply on Mar 6, 2018 1:20 PM by Ryan Rafferty

    Using LOD calculated date from primary data source with secondary data source

    Ryan Rafferty

      Hello,

       

      I have used an LOD to find the first order date of a particular product from my primary data source.

       

      Customer/Part No =

      if[Part No]=[Parameter 1] THEN[Customer Code] END

       

      Date Item first Ordered=

      {fixed[Customer/Part NO ]: MIN([Date])}

       

      Parameter is used to filter what Product (part no) I want to look at.

       

      My secondary data source contains my sales data.

       

      The columns in my secondary source are as follows:

       

      Customer code, Brand ID, Order Date, Net sales.

       

       

       

      The end goal is to look at sales (secondary data source) within the brand_ID before and after the date the particular item was first ordered (derived from primary data source).

      Brand_ID is in both data sources as well if that makes a difference.

       

      I know now that using LOD expressions with calculations from another data source do not work. I am not quite sure of what the work around would be.

       

      Any help would be appreciated. Unfortunately my job does not allow me to publish any of the data I am working with, and I am not quite sure how to recreate this using the super store data sample given the multiple data sources.

       

      Thank you very much!