I have 2 data sources that are not directly linked on loading but have very similar fields to denote the Year and Week
Source 1 is the Plan and will always have all the Years and weeks (e.g. 2024/01, 2024/02), the second source (the Actuals) won't always have data for every week.
I'm attempting to produce a graph that shows Actuals vs Plan but need a way to plot the Actuals onto the same graph as the plan - Can I use applymap for the Year week? I've tried having a common field name but I get a circular error so need an alternative way!
