What I’m trying to do
I’m using the Day Planner plugin, along with the Daily Note (obsidian built-in), Tasks, and Dataview plugins, which it requires. What I want to get is a summary of how much time I spent on a project each day. I’m using tags to identify projects. The Day Planner plugin makes it easy to assign time ranges to tasks, so I would like to generate summaries from that data.
Example lines from daily notes
- [x] 1:00pm - 2:00pm [Updates for search facet](https://example.atlassian.net/browse/ABC-123) #work/abc
- [x] 2:00pm - 3:30pm [[555 Add fields to Location]] #work/abc
Example table I’d like to see, on that daily note:
| tag | duration |
| #work/abc | 2.5 hr |
Bonus feature that would be great in a weekly note: Time summary of all days of the week:
| tag | Monday | Tuesday | Wednesday | Thursday | Friday |
| #work/abc | 2.5 hr | 1.5 hr | 5.0 hr | 4.5 hr | 0 hr |
Things I have tried
I’ve tried dataview queries, but dataview seems entirely built around listing files, not lines of a file. The Daily note + tasks approach uses many lines per file.
I started down the path of using tasks queries, grouping by tag. That may have potential.
Does anybody know of existing solutions? I sure would like to find an easy path to this functionality if it already exists.