Reports in eFrontPro are visualizations of interesting data regarding the system, the courses and the users.
eFrontPro comes with a variety of pre-defined reports. Upon entering the Reports section, in the “Systems” tab you’ll see an overview of “events” and activity for the current day. You can adjust the reference period to yesterday, week, month and year or set a custom date range.
Other tabs contain reports about Users, Courses, Tests, as well as a “Timeline” listing of all user actions.
Depending on the report type, you can filter the data based on Branch, User type, Audience, Group, Job, Skill, etc.
To learn more about how reports enable you perform changes to multiple viewed items at once, visit the How to work with Mass Actions section.
To open the filtering panel, click on the “Filter” button on the top left of a report view.
There will be different options depending on the current view (Users, Courses, Tests, etc.), but the functionality is the same. You select and set a list of criteria, and you filter (“narrow down”) the list of items shown based on whether those criteria match your filters.
For example the default Users tab on the Reports section, displays the list of all Users.
To see just Users from a specific Branch that also belong to a specific Group, open the Filter panel, and select the Branch and Group (leave the other options in their default values), then click “Submit”.
The list will be recalculated to display only the Users matching the criteria you have set in your filter.
You’ll see grey tags next to the “Filter” button, showing what filters are currently active. Click on the “X” of a filter tag to de-activate this filter, or the single “X” next to the filter button to discard all active filters.
When downloading data from a table (using the respective icon next to the filter box), a CSV (Comma Separated Values) file is downloaded. This can be opened using Excel and will appear as any other normal spreadsheet. However, Excel tends to automatically format data, and this may lead to confusions. Take for example the data for the column “Completed/Total” (referring to courses):
Completed/Total 3/7 0/1 5/10
Depending on your regional settings in Excel, this may be imported as:
Completed/Total July-3 0/1 October-5
Which clearly is not what you needed… The solution to this is to use Excel's import wizard: