Report Templates: Tables and Charts

Report Templates: Tables and Charts

Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit").
To create report templates, you use so-called "placeholders". These placeholders are replaced by the candidate-specific content and ratings of your assessment in the final report at the click of a button. 
You can use the placeholders in different ways in your report template. This means that you can not only integrate the placeholders into running text, but also present information from the assessment using the placeholders in the form of tables and illustrations.

Application example: Table

You can also use the placeholders to integrate the contents of the assessment into your report in the form of a table. 
To do this, navigate in Word or PowerPoint to "Insert" in the top menu bar and then to "Table". A drop-down menu with many small fields will appear. Move the mouse over the fields to select how many rows and columns you want your table to have. Then click once on the selected fields and the table will appear in your Word or PowerPoint template. You can then format it as you wish. You store the placeholders in the template in the table in exactly the same place where you want the respective information to appear in the finished report. 
You can integrate any loops and placeholders into a table. To do this, follow the same steps as described above and then select the placeholders that contain the desired information.
Note that you must also end the loop(s) for tables by inserting "{/loop name}" or "{/}".
Below is an example of how to create the competencies, target profiles and competency ratings in a table in your report template. Below is the result you get when you create the report automatically with Applysia.

Template
Competency
Description
Requirement area
Rating
{#competencies}{competencies.name}
{competencies.description}
{target_min} - {target_max}
{competencies.rating}
{/competencies}

Result in finished report
Competency
Description
Requirement area
Rating
Expert knowledge
Extensive knowledge and in-depth understanding in a specific area of expertise.
3.5 - 5.0
5.0
Problem-solving skills


Ability to identify challenges, take an analytical approach and develop creative solutions.
2.25 - 5.0
3.0
Project management
Ability to manage projects from planning through implementation and achieve successful results.
3.5 - 4.5
4.0


You can also format the tables so that individual cells are merged. This can be useful, for example, if you specify competency clusters in one column and want to list all associated competencies and competency ratings in the column next to it. To merge the cells of a column, use the placeholder "{:merge-cells-col 1}".  

Below is an example of how to integrate the table with merged cells into your template. Below this is the result you get when you create the report automatically with Applysia.

Template
{:merge-cells-col 1} Competency cluster
Competency 
Competency rating
{#cluster}{cluster.name}
{#competencies}{competencies.name}
{competencies.rating}
{/competencies}{/cluster}

Result in finished report

Competency cluster

Competency 

Competency rating

Personal competencies

Self-regulation

4.0


Self-confidence

3.0


Resilience

4.5

Interpersonal skills

Communication skills

3.5


Empathy

2.5


Ability to work in a team

4.0


Application example: Diagram

To add illustrations in your report, you can insert a desired diagram into the template in Word or PowerPoint. 

To do this, navigate in Word or PowerPoint to "Insert" in the top menu bar and then to "Diagram". A pop-up window with different diagram types will appear. Select the desired chart type from the menu on the left and then select the appropriate chart. Double-click on the chart or click "Ok" to integrate it into your templates in Word or PowerPoint.
A predefined number of categories (later competencies) and data series (later e.g. overall assessment and target profile) are automatically stored in the diagram. Make sure that the diagram in the template contains the same or fewer categories and data series than will later be integrated into the report. Alternatively, you can delete the additional categories/data series manually after creating the report.
Here you can find an overview of the available chart types provided by Microsoft. You can only integrate the charts provided by Microsoft into your template, as the placeholders and "filling" with assessment-specific information in the final report will not work otherwise.
You can also use placeholders for the diagrams. These are then automatically "filled" with the values from the assessment when the report is created. Not only the candidates' ratings in the individual competencies or exercises are integrated into the diagram at the touch of a button, but also the axis labels and the legend. All the information you see in the template is then replaced by the assessment- and candidate-specific values and content. You can adjust the title of the diagram manually - either in your template or in the final report.
Insert the placeholder in the title of the diagram so that the diagram can be filled with the assessment- and candidate-specific information in the final report. Alternatively, you can also insert the placeholder in Word below the diagram. Further information on the placeholders for the automatic creation of diagrams can be found here.
If you have stored the option "Use labels instead of numbers" in your templates in the Cockpit and use symbols as scale labeling, these cannot be transferred to the diagrams. Please note that the scales of the diagrams will still be labeled with numbers.
In the appendix (at the bottom of this page) you will find a Word document in which various diagrams and placeholders are combined. You can download the file, copy the desired diagram template and integrate it into your report.
Below is an example of how you can use the placeholders to create the charts. Below this is the final "filled" chart with the information from the assessment as it will appear in the final report.


Template

Result in finished report



    • Related Articles

    • Report Templates

      Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit"). You have selected an Assessment to edit it and are in the navigation menu on the left under "Report Templates". If you are not (yet) using the reporting ...

    • Create Report Templates

      Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit"). With Applysia's reporting tool, you can automatically create candidate-specific reports based on your completed Assessment. To do this, you store an ...

    • Edit Report Templates

      Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit"). To edit an existing report template click on the "3 dots" on the far right and then click "Edit". A new pop-up window opens with the editing options. Two ...

    • Report Templates: Placeholder

      Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit"). In this article you will find an overview of all placeholders that you can integrate into your report template. The corresponding placeholders are then ...

    • Create Templates

      Relevant for: Organisation Administrators, Administrators (see "User Roles in the Cockpit"). To create a new Template, first select what kind of template you want to create in the top menu under "Competence model" and "Report". Competence model To ...