1 Reply Latest reply on Apr 26, 2018 9:14 PM by Shinichiro Murakami

    Two data sources with different date fields

    matt hins

      Hi, I have two data sources; a Legacy CRM (2013 - 2017) and a Current CRM (2017 - 2018), and I'm trying to merge the data on the date fields "Created Date" and "createdtime", so that we end up with a continuous timeline, tracking number of Legacy CRM Contacts + Current CRM Contacts by year. I've attached a workbook packaged up with the two date dimensions and prospect counts to illustrate how they don't align. Any pointers on how I could get my date fields to align along a continuous sequence?

       

      Thanks,

      Matt