Skip to main content

Reporting - How do I see the number of mandatory assignments for a Course, and who is not compliant?

Matt Troy
Updated
ℹ️ Info: This article refers to Reporting and Analytics with Power BI. View the FAQ for more details.

In this article, we'll show how with just a few clicks, you can see the number of mandatory assignments for a Course. Then we'll dive deeper to:

To answer this question, we'll use the Learning progress report. Note that by default, the Learning Progress report is pre-set to include mandatory Course assignments only. View this article to see how to switch to view optional assignments.

See the number of mandatory assignments for a Course

  1. Open the Learning progress report
  2. Find the Course title filter
  3. Select the filter to open the properties
  4. Select the Course. Use the search option if required:POWERBI_CourseTitleFilter.png

The 'People' summary metric shows your answer: POWERBI_PeoplePanel.png

In this example, 81 (55.6%) people are assigned the Course. 45 are fully complete, 36 are not fully complete.

From this point, it's possible to select 'View' on the People metric to get more detail. However, where the report is filtered to show results for just one Course (as in this example), there's another way to drill into the detail that will give you more useful filtering options. Follow the steps below to see how.

View a list of Users who are not fully compliant for the Course(s)

  1. Follow the steps above to filter the report to filter results for a Course
  2. In the 'Course assignments' panel, select View:POWERBI_CorseAssignmentSUmmaryView.pngThe resulting table details all Course assignments and includes useful data items to further filter the report, for example:
    • Course Compliance status
    • Primary Group
    • Next repeat training date
      For this example, we'll filter the list to show only Users with a Not compliant' status
  3. Select the edge of the table visual. This will give access to apply further filters to the visual, including all the data items in the table:POWERBI_ClickIntoVisual_TableFilters.png
  4. Select the Course compliance filter. Use the search if required:POWERBI_CourseComplianceFilter.png
  5. Select Not compliant. The data table will be filtered instantly. The resulting list can be exported, saved, and shared with colleagues as required:POWERBI_CourseComplianceFilterSelected.png

Export, save, and share the results

Now you have the results, what next? 

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

Discover more about the Fixed reports

Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.

When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.

Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.

Related articles