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.