Create statistics template
This section explains how to create a statistics template.
You can edit the template on the Excel file downloaded from learningBOX.
*For more details on the statistics settings and how to export the file, refer to Export statistics.
Macros are not allowed in the template Excel file.
Also, shapes used in the template will not be exported.
This process is explained below using the “Single course/folder learning history” template as an example.
Keys to insert
The following insert keys are available in the template.
▼ Information regarding courses and folders
| Items | Keys to insert |
|---|---|
| Title | ${Insert(course_title)} |
| Description | ${Insert(course_description)} |
| Course details | ${Insert(course_detail)} |
| Content in course/folder | ${Insert(course_contents)} |
| Start date of course/folder | ${Insert(access_start_date)} |
| End date of course/folder | ${Insert(access_end_date)} |
▼Items regarding users
The following keys are used to loop data, which is detailed in the section below.
| Items | Keys to insert |
|---|---|
| Name | ${Insert(learner.name)} |
| Login ID | ${Insert(learner.login)} |
| Department | ${Insert(learner.department)} |
| Position | ${Insert(learner.position)} |
| Countdown start date | ${Insert(learner.warning_date)} |
| Deadline | ${Insert(learner.deadline_date)} |
| Start date of learning | ${Insert(learner.learning_start_date)} |
| Study Completion Date | ${Insert(learner.learning_finish_date)} |
| Completion rate | ${Insert(learner.progress_rate)} |
| Total time spent | ${Insert(learner.total_session_time)} |
| Custom fields* | ${Insert(learner.%＊＊＊＊＊＊＊＊%)} |
You can insert the field keys created in the Input field settings.
Enter the field key to the "＊＊＊＊＊＊＊＊".
For more details on the input field, refer to Input field settings.
▼ Other
| Items | Keys to insert |
|---|---|
| Exported date | ${Insert(output_date)} |
| Selected group | ${Insert(group)} |
▼ Keys for looping
The data enclosed by the loop keys can be executed repeatedly, allowing the information to be exported to the specified cells.
| Items | Keys to insert |
|---|---|
| Start loop | ${LoopBegin(learner[])} |
| End loop | ${LoopEnd} |
Loops
The following explain how to use a loop.
Example
Information about the user (name, department, etc.) must be enclosed within a loop start and end key.
The following are examples of how to use a loop. If a key is inserted into the template as shown below, names and departments will be exported for each user.
■ Insert keys
・ Start of loop: ${LoopBegin(learner[])}
・ Name: ${Insert(learner.name)}
・ Department: ${Insert(learner.department)}
・ End of loop: ${LoopEnd}
■ Description in Templates
| Name | Department |
| ${LoopBegin(learner[])} | |
| ${Insert(learner.name)} | ${Insert(learner.department)} |
| ${LoopEnd} |
■Statistics exported
| Name | Department |
| Admin | Marketing |
| Henry Jones | Marketing |
| Jim Thompson | Marketing |
| Hilary Smith | Marketing |
| Kevin Williams | Marketing |
*The keys ${LoopBegin(learner[])} and ${LoopEnd} are used to specify the repetitive process, so they will not be displayed as text on the exported statistics report.
When you use a loop
If you merge cells in the same row as ${LoopBegin(learner[])} and ${LoopEnd}, the loop processing will not work correctly and the output data may be corrupted.
▼Applied: Merged cells are located outside the row where the loop key is inserted.
▼Not applied: Cells are merged within the row where the loop key is inserted.
Excel files that cannot be registered
Excel files that meet the following conditions cannot be uploaded.
・ Formulas and macros are included.
・ An invalid or non-existent template key is being used.
Sheet to be registered
If multiple sheets exist in an Excel file, the leftmost sheet will be registered.
If you download the sample template from the Statistics page, the form will be exported as follows.
