How to trend calculated data by time

Anonymous

Not applicable

3 years ago

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

Forum Discussion

Related content

calculate trend

Trend calculation

WoW trend calculation

Trend calculation in matrix by year

Trend calculation dynamically