{"id":12303,"date":"2026-06-17T08:00:00","date_gmt":"2026-06-16T23:00:00","guid":{"rendered":"https:\/\/support.learningbox.online\/?post_type=how-to-use&p=12303"},"modified":"2026-06-17T08:00:59","modified_gmt":"2026-06-16T23:00:59","slug":"training-stats-template","status":"publish","type":"how-to-use","link":"https:\/\/support.learningbox.online\/en\/how-to-use\/training-stats-template\/","title":{"rendered":"Create statistics template"},"content":{"rendered":"

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\u00a0Export statistics<\/a>.<\/p>\n\n\n\n

\u2003<\/span>Important<\/span><\/span><\/div>
\n

Macros are not allowed in the template Excel file.
Also, shapes used in the template will not be exported.<\/p>\n<\/div><\/div>\n\n\n\n

This process is explained below using the \u201cSingle course\/folder learning history\u201d template as an example.<\/mark><\/span><\/h4>\n\n\n\n

\u3000<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Keys to insert<\/span><\/h3>\n\n\n\n

The following insert keys are available in the template.<\/p>\n\n\n\n

\u25bc Information regarding courses and folders<\/strong><\/p>\n\n\n\n

Items<\/th>Keys to insert<\/th><\/tr><\/thead>
Title<\/td>${Insert(course_title)}<\/td><\/tr>
Description<\/td>${Insert(course_description)}<\/td><\/tr>
Course details<\/td>${Insert(course_detail)}<\/td><\/tr>
Content in course\/folder<\/td>${Insert(course_contents)}<\/td><\/tr>
Start date of course\/folder<\/td>${Insert(access_start_date)}<\/td><\/tr>
End date of course\/folder<\/td>${Insert(access_end_date)}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u25bcItems regarding users<\/strong>
The following keys are used to loop data, which is detailed in the section below.<\/p>\n\n\n\n

Items<\/th>Keys to insert<\/th><\/tr><\/thead>
Name<\/td>${Insert(learner.name)}<\/td><\/tr>
Login ID<\/td>${Insert(learner.login)}<\/td><\/tr>
Department<\/td>${Insert(learner.department)}<\/td><\/tr>
Position<\/td>${Insert(learner.position)}<\/td><\/tr>
Countdown start date<\/td>${Insert(learner.warning_date)}<\/td><\/tr>
Deadline<\/td>${Insert(learner.deadline_date)}<\/td><\/tr>
Start date of learning<\/td>${Insert(learner.learning_start_date)}<\/td><\/tr>
Study Completion Date<\/td>${Insert(learner.learning_finish_date)}<\/td><\/tr>
Completion rate<\/td>${Insert(learner.progress_rate)}<\/td><\/tr>
Total time spent<\/td>${Insert(learner.total_session_time)}<\/td><\/tr>
Custom fields*<\/td>${Insert(learner.%\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a%)}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Note<\/strong><\/span><\/div>
\n

You can insert the field keys created in the Input field settings.
Enter the field key to the \"\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\uff0a\".
For more details on the input field, refer to Input field settings<\/a>.<\/p>\n<\/div><\/div>\n\n\n\n

\u25bc Other<\/strong><\/p>\n\n\n\n

Items<\/th>Keys to insert<\/th><\/tr><\/thead>
Exported date<\/td>${Insert(output_date)}<\/td><\/tr>
Selected group<\/td>${Insert(group)}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u25bc Keys for looping<\/strong>
The data enclosed by the loop keys can be executed repeatedly, allowing the information to be exported to the specified cells.<\/p>\n\n\n\n

Items<\/th>Keys to insert<\/th><\/tr><\/thead>
Start loop<\/td>${LoopBegin(learner[])}<\/td><\/tr>
End loop<\/td>${LoopEnd}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Loops<\/span><\/h3>\n\n\n\n

The following explain how to use a loop.<\/p>\n\n\n\n

Example
<\/strong><\/span>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.<\/p>\n\n\n\n

\u25a0 Insert keys
<\/strong>\u30fb Start of loop: ${LoopBegin(learner[])}
\u30fb Name: ${Insert(learner.name)}
\u30fb Department: ${Insert(learner.department)}
\u30fb End of loop: ${LoopEnd}<\/p>\n\n\n\n

\u25a0 Description in Templates<\/strong><\/p>\n\n\n\n

 <\/span>Name<\/span><\/td> <\/span>Department<\/span><\/td><\/tr>
${LoopBegin(learner[])}<\/td><\/td><\/tr>
${Insert(learner.name)}<\/td>${Insert(learner.department)}<\/td><\/tr>
${LoopEnd}<\/td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u25a0Statistics exported<\/strong><\/p>\n\n\n\n

 <\/span>Name<\/span><\/td> <\/span>Department<\/span><\/td><\/tr>
Admin<\/td>Marketing<\/td><\/tr>
Henry Jones<\/td>Marketing<\/td><\/tr>
Jim Thompson<\/td>Marketing<\/td><\/tr>
Hilary Smith<\/td>Marketing<\/td><\/tr>
Kevin Williams<\/td>Marketing<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

*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.<\/p>\n\n\n\n

\u2003<\/span>Note<\/span><\/span><\/div>
\n

When you use a loop
<\/strong>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.<\/p>\n\n\n\n

\u25bcApplied<\/span>: Merged cells are located outside the row where the loop key is inserted.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u25bcNot applied<\/span>: Cells are merged within the row where the loop key is inserted.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Excel files that cannot be registered
<\/strong>Excel files that meet the following conditions cannot be uploaded.
\u30fb Formulas and macros are included.
\u30fb An invalid or non-existent template key is being used.<\/p>\n\n\n\n

Sheet to be registered
<\/strong>If multiple sheets exist in an Excel file, the leftmost sheet will be registered.<\/p>\n<\/div><\/div>\n\n\n\n

If you download the sample template from the Statistics page, the form will be exported as follows.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>","protected":false},"excerpt":{"rendered":"

\u5e33\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u4f5c\u6210\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3001\u3054\u8aac\u660e\u3057\u307e\u3059\u3002\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306f\u3001learningBOX\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fExcel\u30d5\u30a1\u30a4\u30eb\u4e0a\u3067\u3001\u7de8\u96c6\u3092\u884c\u3044\u307e\u3059\u3002\u203b\u5e33\u7968\u306e\u8a2d\u5b9a\u3084\u51fa\u529b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u300c\u5e33\u7968\u51fa\u529b\u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002 \u300c\u5358 […]<\/p>\n","protected":false},"author":10,"featured_media":0,"parent":0,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","swell_btn_cv_data":"","slim_seo":{"title":"\u5e33\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u4f5c\u6210 - learningBOX\u306e\u4f7f\u3044\u65b9","description":"\u5e33\u7968\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u4f5c\u6210\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3001\u3054\u8aac\u660e\u3057\u307e\u3059\u3002 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306f\u3001learningBOX\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fExcel\u30d5\u30a1\u30a4\u30eb\u4e0a\u3067\u3001\u7de8\u96c6\u3092\u884c\u3044\u307e\u3059\u3002 \u203b\u5e33\u7968\u306e\u8a2d\u5b9a\u3084\u51fa\u529b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306f\u3001\u300c \u5e33\u7968\u51fa\u529b \u300d\u3092\u3054\u53c2\u7167\u304f\u3060\u3055\u3044\u3002 \u2003 \u6ce8\u610f\u70b9 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306b\u306f\u3001\u30de\u30af\u30ed\u306f\u4f7f\u7528\u3067\u304d\u307e\u305b\u3093\u3002 \u307e\u305f\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306b"},"_slim_seo_primary_term_category-how-to-use":0,"footnotes":""},"category-how-to-use":[94],"class_list":["post-12303","how-to-use","type-how-to-use","status-publish","hentry","category-how-to-use-setting"],"acf":[],"publishpress_future_action":{"enabled":false,"date":"2026-09-12 09:01:19","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category-how-to-use","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/12303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use"}],"about":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/types\/how-to-use"}],"author":[{"embeddable":true,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/users\/10"}],"version-history":[{"count":39,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/12303\/revisions"}],"predecessor-version":[{"id":21237,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/how-to-use\/12303\/revisions\/21237"}],"wp:attachment":[{"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/media?parent=12303"}],"wp:term":[{"taxonomy":"category-how-to-use","embeddable":true,"href":"https:\/\/support.learningbox.online\/en\/wp-json\/wp\/v2\/category-how-to-use?post=12303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}