All Collections
Report Generator
Report Generator: Link the PPT Template and the Dashboard elements
Report Generator: Link the PPT Template and the Dashboard elements
Updated over a week ago

The third part of our Report Generator Guidance explains the main part of linking together the PPT template and the elements from the dashboard.

Codes to Alt Text

Each dashboard widget is given a unique element name, to allow the dashboard data to populate the template's placeholders.

Examples of element names

The element name is used as a reference point to link the widget to the corresponding placeholder in PowerPoint within alt text. Multiple placeholders can be connected to one dashboard widget/element name.

Once the element name is added to the alt text of the placeholder, PowerPoint can connect to the dashboard and retrieve the data associated with that widget.

Dashboard: Element naming

Required role:

Report Creator

  1. Open Dashboard Settings and click on Elements

  2. Select a chart or table and edit the element id to make it readable and easy to find:

    1. Ensure that each element id is unique;

    2. Only use Latin letters (a,b,c…) or numbers;

    3. It is case insensitive;

    4. Don’t use the spacebar, instead divide words or phrases with a dash or underscore;

    5. Name the widgets consistently with a naming pattern. For example, use the order Brand_Question_Wave/quarter, e.g. brand1_awareness_l4q.

  3. Repeat this for every single chart and table on your dashboard that needs to be mapped to the template.

Elements naming

See the video below for step-by-step instructions:

Template: Link elements via Alt Text

  1. Open the template

  2. Right-click on any table or chart and go to Alt Text.

  3. Insert the element name from the dashboard into the alt text box.

    1. Use the copy button (under each element name) and paste this into the template to avoid any small errors or changes in the naming.

    2. The element name must be inserted between these symbols in the template: ${element_name} e.g. brand_1 from the dashboard should be inserted as ${brand_1} in the template.

Ensure that you use curly brackets only {…} as you cannot use normal brackets for this function.

Template: Insert placeholders mapped text (e.g. sample sizes)

You can also link a table or chart to the template as text. This is useful for adding question numbers or samples to your PowerPoint template without typing it manually for each slide.

The following steps will show you how to add a sample sizes table to your PPT template.

  1. Copy the previously created and named sample size table to your clipboard and go to the template.

  2. Paste it as text anywhere on the slide that you want the text to appear. Remember to always enclose it within these symbols ${element_name}.

  3. Edit the font, text size, color etc. as you would like them to appear.

  4. Copy and paste the code onto all relevant slides.

The image below shows the first slide of a downloaded report with the sample size table shown in the bottom-left corner.

The sample size table

Upload the template to the dashboard

Once you have linked all elements from the dashboard to the template you can upload the template to DataTile.

  1. Open the Dashboard and switch to EDIT mode;

  2. Open Reports and select Add new report;

  3. In the pop-up window enter the report title and choose to upload the .pptx template;

  4. Once the template is uploaded you can immediately download the new report filled with the current data:

    • Click the ‘snowman’ icon on the right of the toolbar;

    • In the drop-down window, find the report title in the report section;

    • Click on the report title and the PPT file will be downloaded at once.

Instead of Step 4, you can create a report generator button to download each report directly from the dashboard in one click (see below).

Create the Report generator button

If you use generated reports rather often it’s reasonable to create the button which initiates the downloading of the last version of the report:

  • Go to the dashboard and switch to the EDIT mode;

  • Click on the ‘Create a report button’ icon from the toolbar;

  • Select the report which will be downloaded if you have many of them;

  • Switch to the VIEW mode to use the button.

Report Generator button

Did this answer your question?