Workflow · People · Opening soon

Training completion

Track training completion by department and course from your Excel export. See assigned, completed, overdue, and completion rate rounded to 1 decimal.

Book a demo

Someone typed

“show training completion by department and course: assigned, completed, overdue and completion rate as a percent rounded to 1 decimal”

The agent read it as

Show training completion by department and course: assigned, completed, overdue and completion rate as a percent rounded to 1 decimal from LMS assignments export.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

LMS assignments export

CSV export · 45 rows

Step

Count training by department and course

Step 1

Result

Training Completion Summary

8 rows

Schedule

Runs when you say

Proposed

File
LMS assignments export
CSV export · 45 rows
Step
Count training by department and course
Step 1
Result
Training Completion Summary
8 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 8 rows came out.

Download LMS assignments export sample (45 rows)Excel: LMS > Reports > Assignments > Export

What you get back

The result of that run, the rows to look at first.

Training Completion SummarySample data8 rows

Department	Course	Assigned	Completed	Overdue	Completion rate (%)
Sales	Workplace Safety	6	5	1	83.3
Sales	Code of Conduct	4	3	1	75
Sales	Customer Service Essentials	7	5	2	71.4
Operations	Data Privacy Basics	8	6	2	75
Sales	Data Privacy Basics	6	4	2	66.7
Operations	Workplace Safety	7	6	1	85.7
Operations	Code of Conduct	4	3	1	75
Operations	Customer Service Essentials	3	2	1	66.7

8 rows in the result. Sample data: illustrative figures, not business results.

How do you show training completion by department and course?

Export your LMS assignments file to Excel, then upload it to this workflow. It groups rows by department and course, counts assigned, completed, and overdue, and calculates completion rate as a percent rounded to 1 decimal.

How it works

How to use the Training Completion Summary workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Training Completion Summary: questions

Which export should you use for this training tracker?

Use the LMS assignments export. It should include the assignment rows for the training you want to track.

What happens if some rows do not match the training tracker rules?

Rows that do not match the grouping rules are left out of the grouped result. The workflow only counts rows that fit the expected department and course fields.

How do you change the rules in words?

Edit the rule to count training by department and course, then define which columns hold department, course, and training status. You can also change the completion rate format to percent with 1 decimal.