Site Tools

 
 
 

reports

Reports

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.

Reports

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.

Mini How-To: working with report Filters

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”.

Filtering reports

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.

Remove filters

Common issues and solutions

Excel will parse data as dates

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:

  1. Click on file→Import
  2. Choose “CSV file” and navigate to the .csv file you downloaded
  3. In Step 1, choose “Delimited”
  4. In Step 2, select the delimiter you want to use (Comma is the default for eFrontPro, but it may be semicolon too)
  5. In Step 3, select the column that presents the problem, and select “text” as the data format
  6. Finally, select where to put the data (leave as is if you're importing in an empty worksheet)