I’m trying to implement a light and flexible project management system in Obsidian, the key missing piece is rollup. I must be missing something because I couldn’t derive any applicable takeaway from the other posts in the forum.
My projects are made of goals (aka milestones) and activities carried out to complete those goals. Goals and activities are separated into different folders within the overarching Project folder. For clarity Project / 10 goals / 20 activities etc. 10 and 20 are on the same level, as shown here.
The result I’d like to get is roughly something like this but expanded. I’d like to see how all goals and the corresponding activities branch off the original project. I’d like to group the activities by the corresponding goal and to show some additional activities properties like status etc. I was able to achieve this when querying the activities by themselves, but not in the consolidated view
I assume the issue can depend either on (1) the folder structure, (2) on somehow the lack of bidirectional links between or (3) my inability to apply group.by to this use case - pretty sure this is not working.
For example, regarding the folder structure, am I querying the right folder?
As fas as point 2, I have tried to brute force my way through as you can see in each individual page, here, here and here. not sure this is the most elegant way to go about it and I’m definitely open to suggestions and improvement. If this approach is right them I’m doing something wrong with the group by.
There are so many moving part that I believe is not worth to share what I’ve been trying to do - a lot of things. I’m open to receive any suggestions about how to improve my rough attempt. Understand this is a heavy weight, with too many moving parts for me to handle, I hope someone with a good heart and knowledge of dataview is willing to help me out