Thank you @armint, for typing out your workflow here. I’m currently trying to do something similar, and I have a question for you.
If I understand your setup correctly, you have a note for each project, which contains the Dataview query to get the task notes associated with that project. What I don’t get is the “Projects” overview page. In your code example, you query length(tasks) as Total, for example. If I try to reconstruct this, the tasks variable is empty. I assume that is because the project page does not actually have tasks written in the note, but uses Dataview queries to get them from other pages.
Any help with this?