Average for week

Hello,

I've attempted to use the information above with limited success. I've added an Excel workbook which provides the two datasets I'm attempting to combine and a picture to show current status.

The dark blue represents Site Resource Forecast whether it be Day/Night or Total

The green represents Force Reporting totals from Monday - Friday, filterable on Day/Night

What I'm looking for is a third measure that will tell me the average total of the green bars in a straight line, week by week.

In the image below, for example, from 2/1/2021 - 2/8/2021, the new bar or line will show 150.8 (or 151) for every day of that week. When I click on Days or Nights (as seen in the second image), the average for the first week should show 15.4 (or 15) for every day of that week.

https://drive.google.com/file/d/1LTPmcvz1eVWEZ4NIfjqcl4x0AASouSQu/view?usp=sharing