How have folks summarized statistics from multiple sheets to feed a chart widget?
Our marketing folks use a new sheet for every campaign. During the span of a few months, there could be several dozen such sheets active. They are all built from a template and reside in the same folder .
Within each sheet there are several summary fields that can indicate number of tasks, number of unstarted tasks, number of late tasks, and so on.
The marketing leaders would like to know in aggregate the progress of the campaigns. Has anyone successfully "added up" the summary field metrics from a dozen or more sheets and produced a chart widget of them? (I know how to build a summary report, but that doesn't provide the graphic visualization. )