Step 8 - Change Chart Labels
Last updated
Was this helpful?
Last updated
Was this helpful?
Tutorial 1 for Pro Version: Aggregate and Visualize Your Data
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
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.
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:
Filter the students out of the chart
Label the students and display the percentage of 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.
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:
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".
