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.
The following is an example of a "Course/Folder Learning History" template.
Keys to insert
The following insert keys are available in the template.
▼ Information regarding courses and folders
| Items | Keys to insert |
|---|---|
| Course Folder Title | ${Insert(course_title)} |
| Overview | ${Insert(course_description)} |
| Details | ${Insert(course_detail)} |
| Curriculum | ${Insert(course_contents)} |
| Start date | ${Insert(access_start_date)} |
| End date | ${Insert(access_end_date)} |
▼Items regarding users
The following keys are used to loop, which is mentioned below.
| Items | Keys to insert |
|---|---|
| Name | ${Insert(learner.name)} |
| Department | ${Insert(learner.department)} |
| Position | ${Insert(learner.position)} |
| Study start date | ${Insert(learner.learning_start_date)} |
| Study Completion Date | ${Insert(learner.learning_finish_date)} |
| Learning rate | ${Insert(learner.progress_rate)} |
| Total time required | ${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 |
|---|---|
| Output Date | ${Insert(output_date)} |
| Selected group | ${Insert(group)} |
▼ Keys for looping
The data enclosed by the loop keys can be executed repeatedly and the information can be exported to the specified cell.
| 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 in a loop start and end key.
The following are examples to use a loop. If a key is inserted into the template as shown below, names and departments will be exported per 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, and they will not be displayed as text on the statistics when exported.
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: If there is a merged cell other than the row where the loop key is inserted
▼Not applied: If cells are merged in a row where the loop key is inserted
Excel files that cannot be registered
Excel files that meet the following conditions cannot be registered.
Formulas and macros are included.
A nonexistent jumble key is being used.
Sheet to be registered
If multiple sheets exist in an Excel file, the left-most sheet will be registered.
If you download the sample template in the Statistics settings, the form will be exported as follows.
