Summary:
Do you have the need to track content type consumption over time and compare? Let’s create a custom report to get this done!
Requirement Overview:
If any of these requirements fit your end goal, this may be the play for you.
- Requirement 1: Show content type consumption trend over time
- Requirement 2: Compare the trend against other content types
Functional area to be used:
- Reporting > Create
Core Functionality Configurations:
Description:
Use the How many learners have started content and not completed it? explore, to list the number of views per content type over time, then pivot on content type to create line graph.
Configuration:
- Navigate to the Reporting > Create page (/learn/manager/reporting-hub/custom-reports).
- Choose the How many learners have started content and not completed it? report under the Learner Content & Progress section.
- Choose the fields in the below screenshot to display and filter (add other filters if required).
- In the screenshot we selected Content Type, Week-Timestamp Date and Learner Count to display. We selected Content Type and Week-Timestamp Date to filter.
- In the screenshot we selected Content Type, Week-Timestamp Date and Learner Count to display. We selected Content Type and Week-Timestamp Date to filter.
- Choose the Pivot Icon on the Content Type label.
- Click into the Visualization tab to change from a table format to a line graph format.
- Enter the settings below to have a RYG, stacked bar graph with a sum of the quantities at the top.
- Your graph will now look something like this:
- Once you are happy with your graph click the gear icon in the top right corner and choose whether you want to save as a Look or to an existing or new Dashboard.
You cannot use the save to new dashboard option at this step if you'd like it to be in the Group folder and therefore, visible to other users. Choose save to an existing dashboard to add it to a dashboard within a Group folder.
Risks and considerations:
- If the difference in views per content type is large you may want to remove some types to get a clear visual graph.
- In the field and filters section you can choose to display months if you want to filter on a longer period of time.