Reports as Metric Sheets
Is there anyway to use a Report to make chart widgets on a dashboard? I would normally create a metric sheet and use formulas to count items I wanted to illustrate in chart form, but have not been able to do that with a report.
I have one report that contains over 90 sheets and really don't want to have to build that really long COUNTIF formula from all those sheets if I can avoid it.
Any help would be great.