Line Report

Any user with access to Explore (Global Admins, Area Admins, and some Users) can edit a Line Report. All users can view a Line Report.

Pricing

Available on paid plans (Analyst, CLO, and Enterprise).

Expertise

Anybody (both beginners and experts) can use this feature.

What is a Line Report?

The Line Report displays learner performance on a line chart. Choose multiple measures and the Line Report will display values with colored lines. It’s ideal for viewing change in measure values over time.

Creating and Editing a Line Report

Use Explore to create new Line Reports and to configure existing Line Reports.

Line Report Filters and Options

Line Section of Explore

When setting up a new Line Report or configuring an existing Line Report, click Line in the filter menu:

Below are the different options in the Line section:

Organized

On the Organized menu, you’ll choose what you’d like to rank on the Line Report. Just choose an option from the Organized menu and the Line Report will organize data by what you’ve chosen.

For example, if you choose By Day in the Organized menu, your line will be organized by day, and the each measure represented on your line chart will have a point per day that it has data for:

The Line Report also allows you to specify a second dimension. If specified, this will create additional lines per measure, for each item in the second dimension you select. For example, if you select By Group as the second dimension, you will see an extra set of lines for each group. We recommend using the second dimension option only with a small number of measures (ideally just one measure) to avoid too many lines. Your reports are clearer if you keep them simple.

Measures

On the Measures menu, you’ll choose how you’d like to rank what you chose in the Organized menu. You can choose multiple measures for the same Line Report, but we don’t recommending choosing more than 4 to keep your chart clear.

For example, if you choose By Month in the Organized menu and you chose Interaction Count as a measure, the X axis will show the month month and the y axis will show the number of interactions each month:

To add a measure to the Line, choose a measure from the Select a Measure menu and click the Add Measure button next to the menu. You’ll see the measure added to the Line, and the measure will be added to the Measures section. To deselect a measure, click the X next to the Measure in the Measures section.

Chart Type

Chart Type determines if the line chart will shade in the area under each line.

The Line option will not show any shading under the line

The Area option will shade under each line with the same color as the line.

The Area Chart Type is especially useful when you have a pair of related measures where one shows progress towards or a part of another. For example, this Line Report shows a count of times a video was watched at different amounts up until 100%:

Charts

Charts determines if the report viewer will view all measures on the same line chart or separate measures on different line charts within the Line Report. No matter which option you choose, a single chart is always used on the dashboard view.

Single Chart displays all measures on a single line chart.

Charts by measure separates measures onto different line charts within the Line Report.

Gaps

Gaps determines how the report will handle gaps in the data. For example, if a report is organized by day and there was no activity on a certain day, this option determines whether the Line Report will connect the points either side of the gap, leave a blank space, or fill in the gap with zero values.

Connect will draw a line between two points with data if there are gaps between them.

Don't connect will not connect two data points with data gaps between them.

Fill with zeroes will assume all data gaps should be represented by zeroes on the chart and fill the gaps by making the line go to zero in every instance where there are gaps in the data. Filling with zeros is normally the most appropriate for data based on counts since no data is effectively a count of zero.

Unfiltered Line

Aside from editing the report in Explore, Report viewers can filter Line Reports in one of two ways: using Quick Filters at the top of the report, or (for reports with secondary dimensions) using the checkboxes listed at the bottom of the report. By default, when you apply these filters, the Line Report only shows filtered data.

Sometimes, you might want to compare the filtered data against unfiltered data on the same chart. If the Unfiltered Line option is set to Include, when you use Quick Filters or a secondary dimension, the report will show you both the unfiltered data and the filtered data so that you can compare the two.

When using one dimension, the unfiltered line is only visible when using Quick Filters, because without Quick Filters, the main line shows the overall value anyway. With Quick Filters enabled, the report will show a comparison of the filtered data with the unfiltered data. For example, in the screenshot below, you can see a comparison of the overall average score with the average score between a filtered pair of learners.

When using two dimensions, Watershed splits up the data by the 2nd dimension and provides dimension filters below the line chart with checkboxes to compare different items in the dimension. With the Unfiltered Line enabled, Watershed will include an additional item at the top that shows data for all items combined. The can be useful if, for example, you want to compare the overall average score with the average score for a particular learner. In the example below, we can see how Dominga Janssen’s score compares to the overall average and to the benchmark over time.

Advanced Configuration

Advanced configuration is designed to be used by expert users who understand JSON and the properties of xAPI statements.

Certain settings unique to the Line Report are configurable in Advanced Configuration.

Property

Explanation

Example values

line

If true, the graph will display as a line. If false, it will display a line with the area under the line filled in.

false

allowGaps

If true, where there is no data for a particular point along the y axis, Watershed will leave a gap to indicate this.

If false, Watershed will join all the dots with a line across the gap.

true

fillGapsWithZeroes

If true, Watershed will assume points with no data are 0. The value of allowGaps will be ignored.

This is the most appropriate option for count based measures.

false

singleGraph

If true, the data will be displayed as a single graph; otherwise it will display a graph per measure.

false

defaultSecondDimensions

When a second dimension is used, this property defines a list of items that are selected by default and shown on the graph. For reports organized by a dimension that uses an id (most of the default statement property dimensions), use the id of the item rather than what is displayed.

["apple", "orange"]

[12345, 12346]

eventLines

Adds lines representing events and interventions to the chart. See Event Lines.

Event Lines

Line Reports are a great way of showing changes in metrics over time, or the impact that an event or events have had on those metrics. Whether it’s coaching sessions, training events, or communication campaigns, Event Lines offer a way to visualize these key events on reports.

Event Lines are configured in Advanced Configuration using the eventLines property. This contains an array of object, each configured to filter a specific set of xAPI statements representing the events to display. A separate event line is added for every xAPI statement filtered by the event line settings and positioned on the chart based on that statement’s timestamp property.