Report Generator: Splits & For each
The report generator allows you to upload dashboard elements to .pptx file using a predefined template with placeholders. Now there is a solution for dynamic multiplicated charts, which we get using splits and the ‘for each’ option.
By specifying the widget name in the placeholders of the .pptx template, we can generate output with all the propagated charts arranged according to these placeholders. If the number of charts exceeds the available placeholders, the system will duplicate the slide and fill in the additional charts accordingly.
How to export split charts with Report Generator
Start by considering how the charts will be displayed on the slide. If the number of charts is unknown beforehand, the system will duplicate the slide and continue to populate charts.
The widget name used to link the chart and the template is common to all charts here.
For example, we create the following template which contains 6 placeholders for split charts:
This means that we want to see 6 split charts per slide in the exported report, this will look nice and readable. But what if we have 9 split charts? No further action is required.
The system will populate placeholders with the first 6 charts. After the system discovers charts 7, 8, and 9, it will duplicate the slide and proceed. The result will be like this:
You can combine charts multiplied by splits and by for each option on one slide using placeholders accordingly.