# 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**  

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Set_Name_Bucket_PropertyResize.jpg)

#### 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

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Pass_Bucket_Property_To_Measure_2Resize.jpg)

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

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Preview_with_Series_LabelsResize.jpg)

### 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**](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/tutorials/tutorial-1-aggregate-and-visualize-your-data/basics-of-writing-expressions-in-jss.md) for detailed documentation on writing expressions in JSS.

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Set_Increment_ExpressionResize.jpg)

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

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Preview_Student_with_No_Data_FilteredResize.jpg)

#### 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

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Name_Bucket_Property_Label_Students_with_No_DataResize.jpg)

**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**](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/tutorials/tutorial-1-aggregate-and-visualize-your-data/basics-of-writing-expressions-in-jss.md) for detailed documentation on writing expressions in JSS.

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

![](https://github.com/christineolah/illuminate-bi-tool-guide/tree/6c2ef197cc28ebf3e67d3eaa4e8ec3be06367b71/assets/Tutorial_1_Pro_Version_Not_Tested_SeriesResize.jpg)

[**>> Continue to Step 9. >>**](https://colah.gitbook.io/illuminate-bi-tool-guide/tutorials/tutorials-for-pro-version-professional-edition/tutorial-1-aggregate-and-visualize-your-data/step-9-set-chart-colors)