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!
| Year / Week |
Plan |
Actual |
| 2024/01 |
5 |
1 |
| 2024/02 |
1 |
|
| 2024/03 |
|
3 |
| 2024/04 |
3 |
4 |
