AnsweredAssumed Answered

Count of tasks per different levels of a sorted report

Question asked by JessicaFiorini on May 16, 2012
Latest reply on May 31, 2012 by philmodjunk

Title

Count of tasks per different levels of a sorted report

Post

Hi,

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.

Outcomes