Producing a chart on a dashboard to show resource capacity
I have created a report with information about task status and owner for a bunch of projects. I am trying to summarise this on the dashboard as a pie chart (ideally open tasks by owner); however, the chart shows the same owner multiple times in different colours because they have outstanding tasks for multiple projects. Is there a way to simply display open tasks (i.e. in progress, not started) for each person - so if there is a team of 4 people, it should just have 4 segments?