Creating Reports Using Explore

What is Explore?

Explore is Watershed’s report creation tool. Use Explore to fill your dashboards with reports that help measure the impact of your organization’s learning and training data. It provides a number of report types and filter options that enable you to take a closer look at your data so you can find new insights and correlations you might not have discovered otherwise.

Who can use this feature?
 User Types
Any user with access to Explore (Global Admins, Regional Admins, and some Users).
 Pricing 
Available on paid plans (AnalystCLO, and Enterprise).
 Expertise
Anybody (both beginners and experts) can use this feature.

How to Get to Explore

There are three ways to access Explore:

  1. To create a new report, click Explore in the main navigation: explore.png
  2. For an existing report, click the gear icon from your Dashboard: gearicon.png In the menu that appears, click Configure or Advanced Configuration: configguureoradvancedconfig.png
  3. On the top right corner of an existing report's detail page, click Configure: configurereport.png

Using Explore

There are four main sections in Explore:

  1. Report Previews - One preview shows how your report will look on the Dashboard, while the other shows a live preview of your report's detail view. As you update the report type and report options, both report previews update in real time: previews.png
  2. Report Types - Here, you'll choose what type of report you want to create. Use the arrows on either side of the carousel to scroll through every report type:report_types.png
  3. Report Filters - Once you choose a report type, use the options to customize the data your report analyzes:filters.png
  4. Action Menu - After you’re satisfied with your report, save it so you can see it again later or share with others from the Action Menu. Also use it to access Advanced Configuration or leave Explore without changing anything with Cancel:save.png 

Report Types

Watershed has many report types to choose from depending on the type of data you have and how you want to present your findings.

interactions.png

Interactions - Watershed is powered by moments of activity called interactions. Sources ranging from mobile apps to learning management systems are connected to Watershed, and as learners perform actions in these programs, data about these actions is sent to Watershed in the form of interactions. The Interactions Report collects and lists each of these actions.

activity.png Activity - The Activity Report provides in-depth analysis of an activity such as a course, video, or assessment. Beyond providing insights on how learners perform, this report can perform advanced question analysis to make sure organizations are asking the right questions in their assessments.
leaderboard.png Leaderboard - The Leaderboard Report allows you to rank people, activities, or activity types by score, usage, or any custom measure. For instance, use a Leaderboard Report to show a list of your most active users or most viewed pieces of content. This report type is good for exporting tables into a spreadsheet because it shows text-based data.
heatmap.png Heatmap - The Heatmap Report provides an ideal way to quickly compare activity between learners. Like the Leaderboard Report, each Heatmap Report shows text-based data, but also presents a visual representation of your learners’ activities by using varying intensities of color. Darker and lighter backgrounds on cells are used to visually highlight outlier values. For instance, if you are looking at test scores for a group of learners, you can easily identify higher performers because their corresponding colors would be darker.
bar.png Bar - The Bar Report displays learner performance with a bar chart. It displays horizontal or vertical bars based on measure values. You can use multiple measures on the same chart or set up a series of charts that measure anything from score to KPI measurements.
line.png Line - 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.
scatter.png Scatter - The Scatter Report displays learner performance on a scatter plot. Choose two measures, and Watershed displays individual or group performance of those measures on an X and Y axes. It’s ideal for identifying high and low performers on measures such as KPIs, competencies, or assessment scores.
spider.png  Spider - The Spider Report displays learner performance in a spider chart. Multiple performance measures (e.g., KPIs, competencies, or assessment scores) are plotted on the same scale. You can quickly compare how different individuals and groups are performing on the selected performance measures.
range.png Range - The Range Report visualizes change between measure values. It’s perfect to view change of performance measures (e.g., KPIs, competencies, or assessment scores) before and after training, and it can also be used to visualize learners’ engagement with video.
program.png 

Program - The Program Report offers an overview of a pre-defined learning program—like compliance training or new hire training. Watch as your learners progress through courses, videos, assessments and keep up with high-level metrics like average assessment scores and competencies demonstrated. Answer common questions, such as who has or hasn’t completed parts of a learning program and share it with managers and leadership.

pie.png Pie - The Pie Report displays learner performance by showing how smaller parts represent proportions of a whole on a pie chart. Use it to track compliance, show what's most popular on your Learning Experience Platform, or see how people answer questions on an assessment.
correlation.png  Correlation - The Correlation Report allows you to explore relationships between multiple performance measures and find dependent relationships. It’s ideal to help show a relationship (or lack of relationship) between scores on sales training and actual sales numbers.
person.png Person - The Person Report allows you to create learner profiles for anyone in your organization. In addition to demographic information, you see a comprehensive overview of each learner’s activity—including information about course registrations, assessment performance, class attendance, and learning programs.

Report Filters

Watershed provides a variety of filters to use when building your reports. Four main filters—Activities, People, Verbs, and Dates— automatically appear on most report types in Watershed. Some report types also allow you to use additional filters, while Admins can add even more filtering options. In each report, only data that meets all of the conditions of your filters will be displayed. filters.png

Activities Filter

An activity is anything you want to measure (i.e., an assessment, course, survey, video, etc). The Activities filter lets you choose which activities you want your report to focus on.

In Explore, click Activities to pull up the filter: clickactivities.png

Use the search bar to find an activity: usesearchbar.png

Or, click Pick From a List to choose an activity from the list of every activity you have permission to see: pickingfromalist.png

Click the Activity Type dropdown to filter the activities shown by their activity type. This list is automatically generated from the data associated with the activities you have permission to see:activitytype.png

You can choose more than one activity for your report, and the data is narrowed down to any of the activities selected:multiple_activities.png

If you want to deselect an activity you’ve already chosen, click the X next to the activity’s name.

By default on new reports, no activities are chosen. In this case, your report will focus on every activity that you have permission to see.

  Related Activities

Some users can see a Related Activities checkbox in the Activities filter. Learn about Related Activities, how to turn on the Related Activities checkbox, and how to use the Related Activities checkbox.

People Filter

The People filter lets you choose the individuals and groups from your organization that should be included in your report.

Click People in Explore to pull up the filter:clickpeople.png

Use the search bar to find people or groups:usesearchbox.png

Or click the Pick From a List button to see individual people, groups, or group-types that you have permission to see:pickfromalist.png

Select items from Pick people, Pick groups, and Pick group types:afterclickpick.png

If you choose a group type, every group as identified in your data that you have permission to see will be included in your report:grouptypes.png

You can choose more than one person, group, or group type for your report, and the data is narrowed down to the people, groups, and group types selected:multplethings.png

By default on new reports, no people, groups, or group types are chosen. In this case, your report will focus on every person and group that you have permission to see.

If you want to deselect an person, group, or group type you’ve already chosen, click the X button next to the person’s, group’s, or group type’s name.

Verbs Filter

Data is sent to Watershed in the form of individual interactions (i.e., Meredith passed an assessment or John attended a class). The Verbs filter allows you to isolate just the verbs from those interactions and filter reports based on those verbs.

Click Verbs in Explore to pull up the filter:verbsfilter.png

Use the search bar to find a verb:searchbox.png

Or click the Pick From a List button to choose a verb from the list of every verb you have permission to see:pickfromalist.png

You can choose more than one verb for your report, and the data is narrowed down to any of the verbs selected:multpileverbs.png

By default on new reports, no verbs are chosen. In this case, your report will focus on every verb that you have permission to see.

If you want to deselect an verb you’ve already chosen, click the X button next to the verb’s name.

Extensions Filter

Some users can see Extensions filters in Explore. Learn about the Extensions filter, how to turn on the Extensions filter, and how to use the Extensions filter.

Dates Filter

You’re able to select a time range for your report to analyze.

Click Dates in Explore to pull up the filter:datesfilter.png

Use the dropdown to select Trailing or Custom:

  • Use Trailing to select the previous X days/weeks/months/years from when the report is viewed. While the range stays the same, the dates change to keep up with the present day. If you use a trailing date filter, the report will change every day to only look at the data within the selected range.
  • Use the Custom option to choose a specific date range that will not change.

dropdown.png

To remove a Dates filter, choose All statement dates. If you don’t select any dates, the report will analyze all interactions in the account.

It's also possible to set a dates filter with a start date and no end date. Just select a Custom filter option, choose a start date, and click Clear for the end date. The example below sets a filter starting at January 1, 2018 and will constantly update with new data:from.png

 Heads up: the Dates filter looks at the timestamp of the original interaction, not the timestamp when Watershed received the data.

The Time Zone option allows you to control the time zone for your report (the default time zone for reports is UTC):timezone.png

To change the time zone for the report, search for the time zone using the search box and click it in order to use it for the report (here is a list of time zone options):timezone_search.png

The Time Zone option controls:

  • the period of time that your Dates filters use to filter your data.
  • the period of time that measures in your report use.
  • time-based groups of learners.

Card Text

From the Card Text menu, customize the text on the report on both the Dashboard and in the detail view:card_text.png

  • The Title is at the top of the report on both the Dashboard and the report’s detail view.
  • The Summary appears at the footer of the report on the Dashboard.
  • The Description appears at the top of the report’s detail view under the header.

Quick Filters

 Heads up: This feature is being introduced to customers in Spring 2018, so it might not be in your account just yet.

Quick Filters allow your users to filter reports without needing to access Explore. These filters—which are easy to use and can’t be saved—are perfect for providing limited report control to users not familiar with Watershed:Screen_Shot_2018-02-14_at_2.11.59_PM.png

Quick Filters are enabled on an as-needed basis in a report’s Explore configuration. Each report has four Quick Filter options: Activities, People, Verbs, and Dates. For each report, you can choose which Quick Filters (if any) you want to enable by checking the boxes in the Quick Filters section:quickfilters_enable.png

When a user views a report with Quick Filters enabled, he or she will see a Filter option in the top portion of the report:filter.png

Clicking Filter reveals the Quick Filters enabled for that particular report (this example has Activities, People, and Verbs enabled):Screen_Shot_2018-02-14_at_2.11.59_PM.png

Quick Filters work in addition to the report's Explore-configured filters. For example, if a report is configured in Explore to show data about Course 1 and Course 2, Quick Filters could not be used to make the report show data about Course 3. In this example, Quick Filters could be used to only see data about Course 1, or they could be used to see a small date range of data from Course 1 and Course 2.

 Tip: Unless a user has access to Explore, he or she cannot see the report's Explore-configured filters. We recommend using a report's Card Text to let users know what type of Explore-configured filters are on each report.

By default, all four Quick Filters are turned on for every report.

You cannot control which Activities, People, Verbs, and Dates show up in a user's Quick Filters. The Activities, People, Verbs, and Dates shown are based on a user’s permissions.

Quick Filters will affect a report’s download options; the files downloaded from a report filtered by Quick Filters will match the filtered data set.

Report Specific Filters

Each type of report has unique options:

  1. Interactions
  2. Activity
  3. Leaderboard
  4. Heatmap
  5. Bar
  6. Line
  7. Scatter
  8. Spider
  9. Range
  10. Program
  11. Pie
  12. Correlation
  13. Person

Advanced Configuration

Advanced Configuration is direct access the JSON code that controls every report. Check out our Advanced Configuration guide to learn more.

If you create a report without using Advanced Configuration, you’ll hear us refer to that as Simple Configuration.

Creating Reports

To create a new report, click Explore in the main navigation and use Explore to customize the report. Click Save As New Card to create a new report with the options you’ve chosen:saveasanewcard.png

  Only Admins can save reports on shared dashboards. If you’re an Admin, your report will be created on the active dashboard. If you’re not an Admin, your report will be created on your Your Cards page.

Click Reset when you’re creating a new report to remove all filters you’ve chosen:reset.png

Editing Reports

  Only Admins can edit and save reports on shared dashboards.

To edit an existing report, go to Explore for that particular report and use Explore to change the filters and options for the report.

Click Save changes to this card to update the existing report with the options you’ve chosen:savecahngestocard.png

Click Save as new card to create a new report based on the options you’ve chosen. This will not change the report you first accessed from Explore:saveasanewcard.png

  Only Admins can save reports on shared dashboards. If you’re an Admin, your report will be created on the active dashboard. If you’re not an Admin, your report will be created on your Your Cards page.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

If you can't find what you need or you want to ask a real person a question, please contact customer support.