Hi everyone,
I would like to track the time spent on specific tasks across different projects and then create an overview using Dataview, grouped and summed by project and task.
@holroy has already shared an excellent solution here:
However, instead of describing projects using inline fields like
[project:: Something] (timespent:: 0.5h),
I would prefer to use tags. I expect this to scale better, as tag functionality (including auto-completion and reuse of existing tags) becomes especially useful once tracking grows and the number of categories increases.
Example
I have two projects, “Something” and “Different”, each containing multiple tasks to be tracked, for example:
#projectSomething/task1:: 5 min
#projectSomething/task1:: 2 min
#projectSomething/task2:: 15 min
#projectDifferent/task1:: 222 min
#projectDifferent/task2:: 55 min
Desired Dataview output
I would like to generate a Dataview table with somehow like the following structure:
| Project | Timespent |
|---|---|
total projectSomething |
22 min |
total projectSomething/task1 |
7 min |
total projectSomething/task2 |
15 min |
| — | — |
| projectSomething/task1 | 5 min |
| projectSomething/task1 | 2 min |
| projectSomething/task2 | 15 min |
| — | — |
| — | — |
total projectDifferent |
277 min |
total projectDifferent/task1 |
222 min |
total projectDifferent/task2 |
55 min |
| — | — |
| projectDifferent/task1 | 222 min |
| projectDifferent/task2 | 55 min |
Optional: comments column
Ideally, I would also like to add a second column called “comments”, for example by writing:
#projectSomething/task1:: 5 min, blabla
#projectSomething/task1:: 2 min, xyz
#projectSomething/task2:: 15 min, hahaha
#projectDifferent/task1:: 222 min, yes
#projectDifferent/task2:: 55 min, no
Which would result in a table like this:
| Project | Timespent | Comments |
|---|---|---|
total projectSomething |
22 min |
|
total projectSomething/task1 |
7 min |
|
total projectSomething/task2 |
15 min |
|
| — | — | — |
| projectSomething/task1 | 5 min | blabla |
| projectSomething/task1 | 2 min | xyz |
| projectSomething/task2 | 15 min | hahaha |
| — | — | — |
| — | — | — |
total projectDifferent |
277 min |
|
total projectDifferent/task1 |
222 min |
|
total projectDifferent/task2 |
55 min |
|
| — | — | — |
| projectDifferent/task1 | 222 min | yes |
| projectDifferent/task2 | 55 min | no |
Could you please help me with this?
Also, does using tags instead of inline fields make sense for this kind of time-tracking setup?
Thanks a lot for your help!