I'm not 100% clear on the goal, but to relate the two tables mentioned, you may want to Pivot the second source, so that your Dates are all in one column, similar to the first data source -- that way you can Join or Blend on the date, if needed. Again, no idea if this is helpful, but let us know more about what expected results you are hoping to generate (what viz would you like to see once the data is joined). Any mockup of expected results may help volunteers on the Forum with your request -- best wishes!
Thank you for trying to help.
I see what you're saying, You want me to make the second table something like this:
Yet, imagine if you have 40 different marketing sources and and 4 years of leads data. I'd need to create a file with 5*365*40=73,000 raws. I was wondering if Tableau has a way to aggregate the monthly leads, appointments and contracts came from source X and then divide it by a monthly expanse for this source. In this case, table 2 would look like that:
My final goal is something like that: (instead of Media View I'd have appointments and then another line for contracts)