I am creating a project management site. It will be comprised of three primary lists. Projects, Tasks, and Issues. Both the Task and Issues list have a "Project Name" field, which is a lookup to the Projects list. This way I can tie them all together. I will then have a project dashboard page showing the status or project health by red, yellow, green lights.
My question is, how can I get all the tasks associated with a project? Keep in mind this is a basic task list, not workflow tasks. I then need to do a math operation to get a percentage of tasks that are overdue, and assign it a status back in the Project list.
I have site workflow, as shown in the attachment, which will run periodically throughout the day. Currently it is getting a total of all the tasks and overdue tasks. How can I get them on a per project basis instead of a grand total? I'm assuming I need a collection variable, like I'm already doing for the task list collections, but not sure how to take it one step further so that I'm getting the numbers per project instead of the whole task list.