I've created a report with a Heat Grid chart which is working fine and displaying data exactly how I'd want it.
However when I attempt to add the report to a dashboard, it fails to run, returning instead the message "Too many sub charts to generate. Please refine your results".
I'm assuming this has something to do with the number of individual combinations the chart displays, but really there's no way of reducing this, and as stated, it works fine when viewed as a standalone report.
Would appreciate any assistance in resolving this.