*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***
In this article, we'll show how to apply date filters to show completions for a Course between two dates. Then, we'll signpost options to export, save, and share the results.
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.
Filter a report to show completions for a Course between two dates
- Open the Learning progress report (skip to step 5 to show completions for all Courses between two dates)
- Find the Course title filter
- Select the filter to open the properties
- Select the Course. Use the search option if required:
- In the Course assignments summary metric, select View:
- A Table visual lists all Completions for the selected Course. Select the edge of the visual to activate visual-level filters based on table data:
- Select the Course completed date filter. Use the search to find the filter if needed:
- Select Advanced filtering from the Filter type drop-down menu:
- Select on or after from the 'Show items when the value' menu
- Add the first date/time in the range:
- Note the radio button with AND selected. This option does not need to be changed. Select is before from the 'Show items when the value' menu
- Add the first date/time in the range
- Select Apply filter. The table is now filtered to show only completions within the specified date range:
Export, save, and share the results
Now you have the results, what next?
- Save and share a report view
- Organise report views into groups
- Export a table visual straight to Excel
To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area.
Get deeper learning in The Academy
If you’re completely new to reporting and analytics, then Get started: Reporting and analytics with Power BI is the place to start. We'll start by introducing Power BI’s top five features, then, we’ll take a deep dive into each feature, with links to related learning and tips from the Kallidus team along the way.
If you're starting to explore user-created reports, take a look at Power BI Reporting: Deep dive previews. In this short course, you'll get a quick preview of each 'deep dive' scenario. If a scenario sparks your interest, follow the links in the Lesson description to view the full course.
Do you have a question about reporting? Come to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.
Comments
0 comments
Please sign in to leave a comment.