Passing Parameters/Data Between Datasets with HTML5 Charts

Passing Parameters/Data Between Datasets with HTML5 Charts

This document is only for advanced users who are creating SQL-based BI Tool Reports.

Whenever you create a SQL-based BI Tool Report with multiple datasets, you will need to pass paramaters and/or data from the main dataset to the sub-dataset. For example, you must always pass the visibility_sql parameter from the main dataset to all your sub-datasets, or your sub-datasets will not respect student visibility.

STEP 1 - Create a Parameter in your SUB-Dataset

• In your outline, navigate to the Parameters section of your sub-dataset.

• Right-click on "Parameters" and select Create a Parameter

• Name your parameter (for example, "visibility_sql")

• Set the appropriate class for your parameter

STEP 2 - Add Parameter In Your HTML5 Chart

• Double-click on your chart

• Click Chart Data

• Select your Sub-Dataset

• Click the Parameters tab

• Click Add

• Select the parameter you created in your sub-dataset from the drop-down menu

• Click the pencil icon to bring up the Expression Editor

• Double-click on the parameter/field/variable that will feed the data to the parameter in your sub-dataset.

• Click Finish

That's it!

You can now configure your chart as normal, the data from your main dataset will be passed to your sub-dataset when the chart is generated in your report.

Don't hesitate to submit a help ticket to [e-mail] if you run into any issues.