Creating a Custom Report

Creating a Custom Report

OVERVIEW

The Custom Reports module allows you to create custom reports to supplement the native Pluto LMS reports. 
Note: This may require the assistance of a developer. 

USE CASE EXAMPLE:

 Improving Onboarding Training

Company: XYZ Corporation

Scenario: XYZ Corporation recently implemented a new onboarding training program for its employees. They want to ensure that the program is effective and efficient in getting new hires up to speed quickly while minimizing any disruptions to their regular work.
  1. Onboarding Progress Report
  2. Time-to-Competency Report
  3. Feedback and Satisfaction Report
  4. Resource Utilization Report
  5. Manager's Dashboard

By utilizing custom reports in their LMS, XYZ Corporation can continuously monitor and improve their onboarding training program, ensuring that new employees are trained effectively and efficiently, which ultimately leads to increased productivity and reduced time-to-competency.

CREATE A CUSTOM REPORT

Step 1: Click on "Site admin", followed by "Site reports" and then "Custom reports."





Step 2: Click on "Access Reports" and then on "Add report."





Step 3: Give your report (1) a name, (2) and optional description and (3) decide on the export format, then click on "Add."



Step 4: Write your custom SQL query and optionally add filters, then click on "Save changes" once you're happy. 
You may require a developer to do this on your behalf if you are unable to write SQL queries. Click here to learn a basic SQL query.



If you have written your SQL query correctly, your desired output table will now be available, and ready to be filtered or downloaded, in the "View report" tab.


    • Related Articles

    • Custom Profile Fields

      OVERVIEW Customize what information you wish to collect from your LMS users by creating new profile categories and fields. In Pluto LMS, custom profile fields allow administrators to create additional fields to gather and store specific information ...
    • Finding Course Reports

      OVERVIEW In the relevant course, you can find a variety of course reports in (1) course admin, (2) the right-hand drawer and (3) on the "Grades" page. COURSE ADMIN On the "Course admin" page, in the "Reports" tab, you can find the following reports: ...
    • Course Attendance Reports

      OVERVIEW A course attendance report is a document or digital record that provides a summary of who attended a specific training course or session, typically within a Learning Management System (LMS) or training management system. This report includes ...
    • Email Automation / Custom Mailing

      OVERVIEW The Custom Mailing activity allows you to send automated mails to learners enrolled in your course with the following parameters: at course enrollment # days after first access # days after last access # days after first launch of a SCORM # ...
    • Reports API

      block_configurable_reports_get_report_data Arguments reportid (Required) The report id General structure int //The report id REST (POST parameters) reportid= int How to connect to 3rd party data analysis tools: You can also connect to tools like: ...