I have a project summary report that gives me counts of project tasks by status in >50 project sheets. Ex: each project has summary fields for its row tasks like "Complete Count", "Not-Started Count".... My goal is to have a pie/donut chart on my dashboard to show an aggregation of counts from all of my projects.
When I select the summary report and the count columns, the option for pie/donut gray out. As an experiment I selected a stacked column but it then creates a chart with each project individually while I want an aggregated view.
What am I doing wrong?