Summarized Summary Reports and Charting
I am using sheet summaries to calculate project health and want to roll up the metrics from several projects into a portfolio dashboard. I am pulling all of my summary sheets into a summary report and grouping them by project health type (indicators) and then summarizing to get a count of how many projects are red, yellow and green. I am having several issues.
- when I go to report this on my dashboard using a chart, it is pulling ALL the summarized data, including total count at the top, which is messing up my chart. There doesn't seem to be a way to de-select the sheet total at top, even though the data are grouped. See images for context.
When I do select the chart and save it, it doesn't show on the dashboard. I get this error:
I see the note at the top of the summary sheet selection that says "Note: Support for reports with grouping and summary coming soon!" is that what's causing these issues and if so, does anyone know when this functionality will be available? We were so excited to be able to get rid of our helper sheets and use summary sheets instead, but not being able to roll our summary sheets up into metrics to report on the dashboard makes the summary sheet function almost useless for us, which is very disappointing. I am hoping this is just some user error and the functionality is actually there.