Create statistics template
This section explains how to create a template to be registered in the Statistics settings.
Templates are created in Excel files.
*For more details on the statistics settings and how to export the file, refer to Export statistics.
Keys to insert
The following insert keys are available in the template of the statistics settings.
▼Items regarding course
| Items | Keys to insert |
|---|---|
| Course | ${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)} |
| Started | ${Insert(learner.learning_start_date)} |
| Completed | ${Insert(learner.learning_finish_date)} |
| Status | ${Insert(learner.progress_rate)} |
| Time spent | ${Insert(learner.total_session_time)} |
| Field added* | ${Insert(learner.%＊＊＊＊＊＊＊＊%)} |
In the field added, you can insert the key which you have added on the Input field settings.
*The key must be active.
Enter the field key to the "＊＊＊＊＊＊＊＊".
For more details on the input field, refer to Input field settings.
▼ Others
| 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
Enclose the information regarding users (name, department, etc.) with the start and end keys.
The following is an example 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 loop: ${LoopBegin(learner[])}
・Name: ${Insert(learner.name)}
・Department: ${Insert(learner.department)}
・End loop: ${LoopEnd}
■How to insert in a template
| Name | Department |
| ${LoopBegin(learner[])} | |
| ${Insert(learner.name)} | ${Insert(learner.department)} |
| ${LoopEnd} |
■Statistics exported
| Name | Department |
| Henry Jones | sales section |
| Jim Thompson | sales section |
| Hilary Smith | sales section |
| Kevin Williams | personnel section |
| Britony Watson | general affairs section |
*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.
▼Allowed: If there is a merged cell other than the row where the loop key is inserted
▼Disallowed: 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 or macros included
・Non-existent keys are inserted
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.
