Step 8 - Change Chart Labels

Tutorial 1 for Pro Version: Aggregate and Visualize Your Data

Step 8 - Change Chart Labels

Create Bucket Property

Chances are, you want your chart to display the text values of your performance levels instead of the numeric values.

As is, the chart's legend is displaying "Level 1", "Level 2", etc. This step will show you how to change the chart's labels so that they display the full text of your performance levels. (i.e. "Not Meeting Standard", "Approaching Standard", etc.)

• Double-click on your chart

• Click Chart Data > Configuration

• Double-click on the Series Levels you created

• Click Bucket Properties

• Click Add

• Set Property name to "name"

• Click on the Pencil Icon to bring up the Expression Editor

• Double-click on the field that contains the Performance Level Text

• Click Finish

Set Advanced Property

Whenever you create a bucket property, you need to pass the property to a measure.

• Double-click on the Measure you created

• Click Advanced Properties

• Click Add

• Set Contributor to "SeriesProperty" (Use drop down menu)

• Set Property name to "name" (all lowercase, the property name is case sensitive)

• Select Use Bucket Value

• Select the "name" Bucket Property you just created

• Click OK

Now, preview your report, and you should see the chart's labels have changed.

Filter or Label Students with No Data (Optional)

If your dataset includes students with no data (i.e. students who did not take the assessment), you will notice an extra, un-labeled series in your chart. For example, in the screenshot above, you can see an extra series in the chart, that is simply labeled as "Series 5". This series represents the students who did not take the assessment, the students who have no data.

You have two options for handling these students:

1. Filter the students out of the chart

2. Label the students and display the percentage of students with no data

Option 1 - Filter Students with No Data

Using the "Increment expression"

HTML5 charts have an "Increment expression" that allows you to filter data from a specific chart in your report.

To filter the students with no data out of your chart,

• Double-click on your chart

• Click Chart Data tab

• Click Pencil icon next to Increment expression to bring up the expression editor.

• Enter the following expression:

$F{2016-2017 SBA Summative (Final) ELA Performance Level}!=null

What is this expression doing?

"!=" means "does not equal". So, the expression is saying, include only students whose ELA Performance Level is not empty.*

Refer to Basics of Writing Expressions in JSS for detailed documentation on writing expressions in JSS.

Now, preview your report. The extra "Series 5" series is now gone; the chart is no longer showing students with no data.

Option 2 - Label Students with No Data; Display Percentage

If you want to display the percentage of students with no data in your chart, you need to adjust your "name" Bucket Property so that this group of students is properly labeled.

• Double-click on your chart

• Click Chart Data > Configuration

• Double-click on the Series Levels you created

• Click Bucket Properties

• Double-click on your "name" Bucket Property

• Enter the following expression:

$F{2016-2017 SBA Summative (Final) ELA Performance Level}==null
  ? "Not Tested"
  : $F{2016-2017 SBA Summative (Final) ELA Performance Level Text}

• Click Finish

What is this expression doing?

The expression is saying, IF the student's ELA Performance Level is blank/empty, THEN label the student as "Not Tested". ELSE, label the student using the ELA Performance Level Text.

Refer to Basics of Writing Expressions in JSS for detailed documentation on writing expressions in JSS.

Now, preview your report. The students with no data are properly labeled as "Not Tested".

>> Continue to Step 9. >>