Here’s a scenario that you might encounter, the learning platform tracks your up-to-date completion in real time and you also need to send a simple report showing the completion percentages for certain areas within your business. Here’s how.
Create a new report and add your parent locations:
Add locations if you need to.
Now you need to add some “counts” data. Pick Calculate, then Total Count:
The two counts that you’ll need are:
Username - this will give you total number of people who have courses assigned to them
Last Completed - this will give you the total number of completed courses
Use filters to get just the data that you need (in this case I added a filter on Location Parents that included if text contains ‘Rise and Dine Stores’).
Press Export to see your data as a CSV file:
Your export will be a CSV file so the first thing to do is to make it a spreadsheet file using your tool of choice. Common files are .xlsx as supported by Microsoft office, Google sheets and others.
Open your spreadsheet file and create a new column. Add a formula which is “=C2/B2” - this will perform a calculation that is “The total number of completed courses divided by the total number of people who have courses assigned to them”
Apply any formatting to your report as required and then it’s ready to send: