Creating Pivot Chart Using Related Tables

Occasional Visitor

Hi,

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.

 

Any help or direction would be appreciated.

Kevin_Estes_0-1615233725816.png

 

 

0 Replies