How to trend calculated data by time

[ssee]

I have a data table that has the following columns: (work week), (condition pass), (team).  There are multiple rows of the same work week, where each row is an instance of a condition passing or failing (1 or 0) and each row is associated with a team.  There are multiple teams.

 I want to plot the % of "condition pass" per week, where % of condition pass = sum of "condition pass per week"/count of teams/week.

My challenge is getting the "% of condition pass" by week and plot it by week.  Everytime I add a new week (multiple rows of data for a week) to the data set, the values from the previous weeks change.  How do I fix this problem?

Thanks

ssee

[PhilipTreacy]

Hi @ssee 

Please supply your data file, or at least a subset of dummy data that accurately represents its structure.

Regards

Phil

[ssee]

Fundamentally if there are 100 rows in week 10/3/2022 and the sum of "qualified" in week 10/3/2022 is 10, then the % qualified is 10%.  I need to plot the % qualified for each week and each week will have varying counts of rows.

Week	Team	Qualified
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	1
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/3/2022	Team 2	0
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	1
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0
10/10/2022	Team 2	0