Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Solution attached. Set this up to be dynamic to the past week for whenever it is run (not factoring in time of year and temperature of course for when that precipitation might actually be rain instead of snow).