How to sum table values from last N days?

What I’m trying to do

I have a table tracking time spent on activities:

Date Minutes
2025-01-18 30
2025-01-13 15
2025-01-10 8

I want to create a Dataview query that calculates the sum of Minutes, but only counting entries from the last 7 days. This would help me track my weekly limits. (Ideally, it would also show time remaining for a specified time limit e.g. for 90 mins/week.)

  • The table is in my current note (not pulling data from other files).
  • The table entries are not necessarily on consecutive days.
  • I want to keep using this simple two-column table structure if possible, rather than switching to inline fields or YAML.

How can I correctly query this table format to show the rolling 7-day total?

I’m also open to alternatives—maybe another plugin or an iOS app exists to fill this need?

Things I have tried

I’ve tried variations of the date filtering syntax but keep getting “No results” or errors about null values.