I am trying to create a line chart for my training team that shows 2 lines: training completion and target completion rates over time. The training completion table generates a timestamp and completion percentages from a pivot table whenever those metrics update. The Pivot table gets info from another table that handles raw data reports. The target completion table is static and currently I'm using a Week Beginning Date column and a T- Column (8 rows for each week of training) with expected completion percentages.
I would LOVE suggests on how to create a Pivot to accommodate this data. I feel like I need to align the target and actual dates somehow, but not sure of the approach or whether this is what I am missing.