Weekly Contributions Against Weekly Goals in Analytics

Hello,

I am trying to create a widget that is a line chart comparing running totals of contributions by fiscal week from 2 years ago, last year, this year, and a goal line for this year.

Ideally, I would have the below widget with an additional line for 2020 goal:

I created a similar widget based on one of Chris Wallingford's February NYCTUG examples.

The below filters on Contribution Date - Date in Weeks, selecting only the weeks of this Fiscal Year. My X axis is Weeks in Date, and then I have 3 values:

1. This Year Actual

• RSUM of total contribution amount

2. This Year Goal

• CASE WHEN  [Min Fiscal Week Of Year] = 1 THEN 75000

when [Min Fiscal Week Of Year] = 2 THEN 205,000

(and so on)

ELSE NULL END

3. Last Year Actual

• ([Total Amount], Prev([Weeks in Date],52))
• I cannot figure out how to get this value to RSUM

Can anybody help me RSUM last year's actuals in the second example?

I get an error with RSUM (([Total Amount], Prev([Weeks in Date],52))

I get the below with (RSUM([Total Amount]), Prev([Weeks in Date],52)), which I think is summing all of last year's giving plus this year's.

I am also wondering if there is a way to use Fiscal Week instead of Calendar Week in the second widget, especially since it doesn't look like I can select future weeks in my filters. I guess I am looking for a kind of combination of the two widgets.

Thanks for your help! I am happy to share the Dashboard as well if that's useful.

Kelsey