A group report simplifies the complexity of your data by allowing you to combine information you collected from multiple responses of your assessment, into a single comprehensive report. This not only saves time but also provides a holistic view of trends and patterns across different respondents.
Aggregate reports are an extra feature with an additional fee. Don't hesitate to get in touch with sales@pointerpro.com for additional information.
It is important to note that in the group report, you can only use variables that are related to averages or question text. You can find them in the variable selector. Variables that are related to individual responses (for example answer on question or answer on intro fields) can not be used in the group reports.
This guide will illustrate the process of creating a group report by using an Employee Happiness assessment as an example. Respondents have the option to choose their company and department before answering the questions. The resulting report provides insights into the overall happiness of employees within the chosen company, both collectively and categorized by department.
This guide will teach you how to:
- Add questions
- Add custom score
- Create formulas with filters
- Create the Group PDF report
- Add predefined filters
- Download the group report
1. Add questions
1.1 Create the Questionnaire
At the Questionnaires tab, click Create Questionnaire.
Click Start from scratch so you can add your own questions and style.
1.2 Add your questions
To add your questions just click the "?" Question button to insert your first question.
You'll be shown different question types you can choose from. Choose your desired question type and click Add.
For this example, we are going to use the Text choice and Slider numbers question types. The first two questions are about the Company and the department of the respondent.
The remaining questions are about employee happiness.
2. Add custom score
To enable custom scoring, go to the Extra Options tab and toggle the button.
Now go back to your questions, and add a score next to each answer option.
Note that the custom score for the slider number question type is calculated automatically (1-10). All you need to do is to enable the custom score for this question.
3. Create formulas with filters
3.2 Create formulas and add filters
3.1 Formulas Introduction
This step is critical. Your formulas and filters enable the creation of a group report and facilitate score calculations. Within the formulas editor, you can add variables and create mathematical calculations.
The toggle buttons provide additional options to refine your formulas. More specifically:
- Use Rounded Numbers: This toggle allows you to round the results to whole numbers for a cleaner presentation.
- Include Multiple Responses in Formula Calculation: Enabling this toggle allows you to aggregate data, create group reports, and calculate averages based on multiple responses.
- Recalculate Formula on Report Generation: When the report is requested, this setting triggers a recalculation of the formula in the backend. This ensures that responses meeting the filter criteria are accurately accounted for, providing access to the most recent data. This feature is useful when using a formula with a variable that can change over time such as response count. Note that this feature is available on request.
- Apply Predefined Filter When Requesting Report: Enabling this toggle is necessary to create predefined filters in your PDF.
3.2 Create formulas and add filters
To create your formula, click on the Extra Options tab and select Formulas in the Custom Scoring section.
Click on the Create Formula button and insert all the data. In this scenario, we require a total of 30 formulas.
Considering we have 5 departments and 4 questions, we need to create one formula for each question within each department. Additionally, 4 formulas are necessary to calculate the total scores for each question across the entire company. Furthermore, 6 formulas are needed to determine the total scores for each department and the overall company.
Let's see how you can set up the formulas for the first question and the total scores.
In the first formula, our aim is to create the company's score for question 3, focusing on Work-life balance. We utilize the variable *|q3_custom_score|* because we want to use the custom score from question 3. To standardize the score to 100, considering the question's maximum possible score of 4, we multiply it by 25.
We enable the toggle buttons as shown in the image below. There is no need for a filter, as we will filter later on per company.
Formulas 2 to 6 use the same value as formula 1 in the formulas editor, *|q3_custom_score|**25. However, this time, our focus is on department-specific filtering, so we implement a custom filter.
You can create the formulas for the rest of the questions in a similar way. Remember to adjust the multiplier if your maximum score varies from 4. For instance, if question 5 involves a slider question with a maximum custom score of 10, the formula value for that question should be *|q5_custom_score|**10.
To generate total scores for specific departments and the entire company, sum up the scores for each question. Then, standardize the total by applying a multiplier to achieve a score of 100.
It's important to note that you don't need to add a filter to the formula for the overall company score.
You should create formula filters for the total score of each department.
Upon completing your assessment setup, be sure to save your progress!
4. Create the Group PDF report
While your assessment editor is still active, you can click on the Report Button and then select +Create a new report.
A new modal will appear, asking you to choose a template. In this instance, select the Empty template and click Next.
In the new modal, select the Group report type and click Next.
The report editor will open, and you can start adding your widgets. Creating a group report follows a similar process as an individual report. However, when generating charts and incorporating variables, you'll notice a reduced list of options, displaying only variables applicable to the group report.
Feel free to utilize the formula variables you've set up for your assessment in the charts.
The above chart uses the variables *|f1_avg_result|* - *|f6_avg_result|* as we want to present the results of the work-life balance question. You can create a chart (or more) for each question using the rest of the formulas.
5. Add predefined filters
After you've finished creating your PDF and included all your content, save your work and navigate to the Share tab.
Select the Predefined Filters tab, and click on the +Create filter to create your filter. You can create as many filters as you wish.
This step is optional and depends on your setup. You can either create predefined filters in the PDF editor or create them later on when you want to generate the group report.
6. Download the group report
After collecting your responses, you can download the group report.
Given the complexity of this setup, it's advisable to conduct thorough testing before deploying your assessment. You have the option to clear all responses prior to distributing the assessment to your contacts.
To download the group report, go to the results of your assessment and click on the Download button.
In the new window, within the ReportR PDF (Group) tab, you can pick one of the predefined filters you crafted in the PDF editor. Select your choice from the dropdown menu.
Alternatively, you can select the Custom filter from the dropdown menu and add as many filters as you want by clicking the + button.
Once you've applied your filters (in this case, just one for the company), click on the Download button. In this example, we downloaded the group report specific to Company A, which provides a detailed breakdown by question and department.
What's next?
- An Individual vs Group report lets you compare how one person's answers compare to those of a group. This report type brings together the Individual and the group report types. This means that you can create a report to see at a glance how an individual's response stands against those of a specific group of your choice.
- Email invitations are messages sent to your saved contacts containing a link to your questionnaire and are fully customizable. It is the best way to inform your contacts about your new questionnaire, and at the same time, by using our analytics tools, to track who has opened and clicked on your message.
- A Contact listincludes the people to whom you will email a questionnaire invitation and it allows you to send your questionnaire to a lot of people simultaneously, using the same invitation.