December 5 2019

How To Zoola: Interactive Dashboards Part 2- Using Charts as Filters

Written by Erin Melvin

Solve The eLearning Professional’s Biggest Challenges: How To Get The Most From Your Budget While Increasing ROI
Free White Paper
Learn More

- 4 MIN READ - 

The power of Dashboards to show insights across different data points comes from integrating filters across dashlets.  You can start with a high overview of what’s happening across your LMS and then with a couple of clicks see a much more specific picture, such as who has completed a specific course in the past month.

In our last How To Zoola post, we showed you how to link dashlets in a dashboard using parameter mapping.  This month, we’ll take that one step further to show you how to use your charts to filter other dashlets.  

Here, I’m using a common request to show number of enrolments by course within a certain course category, with the ability to drill down to see completion rates by course. 

 

For this example, I’ve built a dashboard with two reports: 

  1. A bar chart showing number of enrolments by course
  2. A table report showing completion status by user and course

 

Once you’ve added your dashlets to the dashboard designer, try the following:

 

  1. Right click on your chart dashlet and select “Properties…
    Zoola Newsletter - December Images - 1. Properties


  2. Select the Hyperlinks tab and then check the Enable chart hyperlinks box:
    Zoola Newsletter - December Images - 2. Enable Hyperlinks

    Keep the “Update page” option in the dropdown, then click “Map Parameters”.
  3. Click “Yes” on the confirmation popup:

    Zoola Newsletter - December Images - 3. Confirm

  4. Use the Parameter Mapping popup to map your chart (Number of Enrolments by Course) as the Source Dashlet that will control the Dashlet affected, Course Completions by the Course filter.
    Zoola Newsletter - December Images - 5. Parameter Mapping

  5. Click OK

 

You can see that I’ve set up this dashboard to first look at the results by Course Category, then to drill down to the Course level using the chart.  Here, I’ve used the chart to select the Company Orientation course.  Zoola Newsletter - December Images - 6. Dashboard
Finally, I used Conditional Formatting on the table report to highlight the completion status.  

 

Click on the following links for more information on using filters in Zoola Analytics:

 


 

Maximize Your Revenue, Efficiency & Learning Effectiveness