Per Project Query Field

I am trying to get a count of the number of in progress tasks assigned to each user. I managed to do so globally by adding a query field to the person entity.

What I would also like to do is have this functionality done per project. In a project page I would have a list/graph of all the artists and the number of shots they have assigned to them which are in progress. Is there a way to achieve this?

One way I managed to achieve this is by making a graph of the Task entity and graph by assigned to. In theory this works but it has a limitation of not showing the artists with 0 tasks. Any idea how I can go around this please?

1 Like