Skip to main content

Advanced Insights - Combining Data from Learning Plan and Courses

  • September 8, 2025
  • 3 replies
  • 117 views

ldlmcoitrg
Contributor III
Forum|alt.badge.img

Hello, 

I am testing the Advanced Insights in Docebo and would like to know if anyone has tried combining data sets from Learning Plans and Courses. I was able to use a pivot table for the course completion, but it is still in a separate table from the learning plan completion rate.

We would like to see a Learning Plan Completion Report that provides detailed insights into learner progress across structured learning plans. Power Users can see the report filtered by the learners assigned to them. Each record includes:

  • Learner’s Firstname, Lastname, Email
  • Learning Plan Code and Name
  • Expected Learning Plan Completion Rate
  • Learning Plan Completion Percentage
  • Number of Enrolled, Completed, In Progress, and Not Started Courses

This format enables easy tracking of individual progress and identifies learners who may need support or follow-up.

Here’s the sample table:

 

Any ideas on how this can be implemented in Advanced Insights? 

Thank you!

3 replies

gerrodhudson
Docebian
Forum|alt.badge.img+1
  • Docebian
  • September 8, 2025

Hello you should be able to just use the Learning Plan dataset which already has course information in it. Can you take a look at just the Learning Plan dataset and tell us what is missing for you use case?

FYI you can’t combine dataset in Advanced Insights


ldlmcoitrg
Contributor III
Forum|alt.badge.img
  • Author
  • Contributor III
  • September 8, 2025

Hello you should be able to just use the Learning Plan dataset which already has course information in it. Can you take a look at just the Learning Plan dataset and tell us what is missing for you use case?

FYI you can’t combine dataset in Advanced Insights

 

Thanks for clarifying. After testing some of the data fields, I was able to find some of the data I needed. However, is there a way to filter the enrolled courses to show only mandatory courses? The Actual Completion (lp_progress_rate) only counts the mandatory courses for the computation but the Enrolled column (enrollment_status) counts all courses.

Also, is there documentation for adding filters within the dashboard? Power users need to filter the Learning Plan Code per cohort. 

 

 


ldlmcoitrg
Contributor III
Forum|alt.badge.img
  • Author
  • Contributor III
  • September 9, 2025

Sharing that I was able to add the filter in the dashboard through these steps, in case anyone needs it: