4 week rolling average

[MikeJones]

I have loaded data from 14^th July 2021 to 24^th November 2022 into Qlik Sense.   I have created a table to show daily data that uses a filter pane to allow the user to choose a certain week.

For example, the user has chosen week beginning 7^th November.

	Total Jobs	Completed	Completed Rate
07-Nov-22	778	678	87%
08-Nov-22	801	750	94%
09-Nov-22	500	400	80%
10-Nov-22	450	389	86%
11-Nov-22	652	501	77%
12-Nov-22	101	89	88%
13-Nov-22	28	27	96%

I’ve added a line chart showing the completed rate (Completed/Jobs) which is a master item.  I wish to get the average completed rate for the previous 4 weeks shown in the chart.  In this example it would cover 10 October to 6 Nov or week beginning 10  Oct 2022 to week beginning 31 Oct 2022

Should I choose week beginning 10 Jan, the 4 week average would cover 13 Dec 2021 through to 9 Jan 2022 or week beginning 13 Dec to week beginning 3 Jan 2022.

I have tried RangeAvg(Above(Avg({<WeekStart(PlannedDate)>}[Completed Rate]),0,4))*Avg(1), but it doesn’t work.