I came up with a formula, but it does not work across additional dimensions. For example, I have a column for "region" and want line plots for each region. The expression doesn't allow for splitting out the additional dimension:
This is the rolling 7-day count of tests performed. (this just the denominator in the positivity average I ultimately need).