Using your Designer licence in Analytics allows you to create views such as the total number of completions, per level within a Learning Experience. This can be demonstrated through a range of widgets within Analytics.
In order to show these figures, the LXP Data Model will provide the best results. In this example, we will show you how to display level completions within a column chart.
Showing Level Completions as a Column Chart
Within the Template Dashboard, ensure that your widget is selected to be a Column Chart:
The next step is to start populating the chart with the data available within the Data Model.
Categories: For this chart, this is no data populated
Values: This will be populated with data to provide an overall count of the total number of levels completed.
Break By: In order to show the completions by level name, this is where the level names will be defined.
The next step is to add data to the values.
It is recommended to apply a count to the overall number of completion dates for all levels within the LXP. This can be filtered down further down the line.
It is useful to note when dealing with values within Analytics, the system will automatically default to calculating the unique values.
For this example we want to change this to the total value, which can be easily done to include all completion dates by altering the formula that Analytics is calculating:
What is the difference?
Count - In this example if using the Count function, it will only count the unique completion dates in days. This means that if 2 users completed the level on the same day, only 1 of those completions will be recorded within Analytics using this function.
DUPCount - When using the DUPCount function as per example, it will count the duplicate completion dates in days. This means that if 2 users completed the level on the same day, both completion dates will be counted within this formula.
Below is how your chart would look, up to this point:
Adding Data to Break By:
It is now time to split the data out to the respective levels. To do this you would choose the level name from the available data.
You have yet to apply filtering to your chart, so expect to see data across the entire LXP.
Below is possibly how the widget will look before filtering is added:
Adding a widget filter:
For this example, we will apply a filter for the overall Learning Experience name.
Within the filter for the course name, you will be able to choose from the drop down box:
After the widget is filtered for a specific Learning Experience, the widget will only show the levels that have been completed as per the chosen course:
Adding customisation:
It is also possible to rename the formula, by renaming the Values section of the widget so it better explains what the data is showing:
Changing the bar colours:
To change the colour of each bar, select the course name as shown below and choose a new colour.
Design options:
Within the design tab of the widget it is possible to change the layout;
Applying the widget:
Once your data has been added, filtered and designed, the widget is now ready to be added to the dashboard by clicking the Apply button.
Once added to the dashboard, the widget can then be given a title to make it descriptive of what is being displayed: