Count of tasks per different levels of a sorted report
I have a database with three main tables. Lesson-->Lesson-Task<--Task. Lessons are organized by several layers of information: Domain, Level, Week, Lesson. I have built a report that organizes the info thusly:
Sub-Summary part: Domain
Sub-Summary part: Level
Sub-Summary part: Week
Sub-Summary part: Lesson
Sub-Summary part: Task name, conatins portal to the task record in the Lesson-Task table
What I am trying to do is have stats on the completeness of tasks on the Domain, Level and week levels. So, I'd like to say that for the whole Domain of geometry, x% of lessons have open tasks assigned and x% of tasks have been recieved. The same thing for Level. So Geometry level 3 has x% of lessons with tasks assigned and x% of tasks have been recieved. And lastly, Geometry level 3 week 2 has x% of lessons with tasks assigned and x% of tasks have been recieved. The task status is indicated by a Lesson-Task:status field that I include in the portal. I will also need to note how many lessons do not have any tasks assigned.
Does this make sense?
I have tried my hand at a slew of calc fields but failed gloriously. Thanks.