Illuminate BI Tool Guide
  • Introduction
  • Example BI Reports
  • What is BI Reporting in Illuminate?
  • Getting Started Using BI with Custom Reports
    • Setup Jaspersoft Studio
    • Prepare Your Data Set
    • Create a Basic Jasper Report
    • Publish My Report to Illuminate
    • Edit Report After Publishing
    • Display Selected Filters on Your Report
  • Get Started Using BI with SQL
    • Access Data Via ODBC Connection
    • Learn the Schema
    • Setup Jaspersoft Studio for SQL
    • Create a Basic Report with SQL
    • Publish My Report (SQL Method)
    • Adding Input Controls
  • Tutorials
    • Tutorials for Free Version ("Community Edition")
      • Tutorial 1: Categorize and Aggregate Your Data
      • Tutorial 2: Using Jasper Report Bands
      • Tutorial 3: Student Roster Report
      • Tutorial 4: Student Roster with SQL
      • Tutorial 5: Summary of Performance
      • Tutorial 6: CELDT Longitudinal Summary
    • Tutorials for Pro Version ("Professional Edition")
      • Tutorial 1: Aggregate and Visualize Your Data
        • Step 1 - Create a Custom Report
        • Step 2 - Download Your Data
        • Step 3 - Create a Data Adapter
        • Step 4 - Duplicate Template. Link Data Adapter
        • Step 5 - Set Class for Numeric Fields
        • Step 6 - Add & Configure Chart
        • Step 7 - Resize Chart. Preview Report.
        • Step 8 - Change Chart Labels
        • Step 9 - Set Chart Colors
        • Step 10 - Repeat for Other Data Points
        • Step 11- Install Your Report
      • Tutorial 2: Using Report Bands
        • Step 1 - Duplicate Report from Tutorial 1
        • Step 2: Create Your Group
        • Step 3: Create a Sort Field
        • Step 4 - Copy & Paste Your Chart
        • Step 5 - Set Reset Type and Evaluation Time
        • Step 6 - Change the Category Level
        • Step 7 - Add Site Name Field
        • Step 8 - Grade Level Sorting
    • CrossTabs Tutorial - Create, Format, and Style a CrossTab
      • Step 1 - Create Your CrossTab
      • Step 2 - Size and Position Your CrossTab
      • Step 3 - Format and Style Your CrossTab
  • Homework 1 - BI Workshop Follow Up
  • BI Tool Cheat Sheet
  • JasperSoft Studio Tips, Tricks, & FAQs
    • Basics of Writing Expressions in JSS
    • Rounding Decimals
    • Working with Dates in JSS
    • Conditional Styling in JasperSoft
    • Custom "No Data" Message
    • Create Multiple Summary Bands
    • Create Hyperlinks or "Tabs" to Connect Sets of Reports
    • JSS Community Edition
      • Adding Data Labels to Your Chart
      • Customizing Colors in Your Charts
    • JSS Professional Edition Only
      • HTML5 Charts
        • Data Labels: Enable, Customize, & Round Data Labels
        • Tooltip: Customizing the Tooltip
        • Keeping Colors Consistent in HTML5 Charts
        • Adding Drill Down to a Chart
        • Prevent Tooltip from Being Cut Off
        • Sort the Bars in Your Stack - Ordering the Series in Your Chart
        • Passing Parameters/Data Between Datasets with HTML5 Charts
        • Add Plot Lines to your Chart
        • Add Colored Zones or Plot Bands to Your Chart
        • Change Bar Colors Based on Bar Value
    • Rolling Over Your BI Tool Reports
    • "Current" Columns in Custom Reporting - To Use or Not to Use?
  • Report Design Best Practices
  • Installing the Illuminate Font Set
  • Report Templates
    • Blank Templates - Report Starters
    • Using the Report Templates
    • Multiple Measures Site Comparison Report (Tutorial 5)
    • EL Reclassification Report
    • EL Reclassification Report v2
    • RFEP Monitoring Report
    • Student Rubric Template
    • Michigan Report Templates
      • PSAT and SAT College Readiness Report
  • BI Tool User Community
Powered by GitBook
On this page
  • The Problem
  • The Solution: Bucket Properties
  • Directions
  • Step 1: Navigate to Chart Configuration Screen
  • Step 2: Add the “color” Bucket Property
  • Step 3: Add “color” Advanced Property to your Measure

Was this helpful?

  1. JasperSoft Studio Tips, Tricks, & FAQs
  2. JSS Professional Edition Only
  3. HTML5 Charts

Keeping Colors Consistent in HTML5 Charts

PreviousTooltip: Customizing the TooltipNextAdding Drill Down to a Chart

Last updated 5 years ago

Was this helpful?

The Problem

Colors in charts may get mis-matched or mis-aligned when the dataset does not include students at each performance level.

Example

In this example, we want the colors in the left chart to match the colors in the right chart, even when not all four performance levels are represented. For example, we want the “On” category to always be blue, no matter how many performance levels are represented in the dataset.

The Solution: Bucket Properties

In order to ensure the colors for each performance level remain consistent even when the dataset does not include students at each performance level, we need to use the Bucket Properties in the HTML5 charts.

Directions

Step 1: Navigate to Chart Configuration Screen

  • Double-click on the chart

  • Click Chart Data

  • Click Configuration

  • Double-click on the Series Levels

In this example, the “Series Levels” represent the 4 performance levels that create the individual bars in the stacked bar chart.

Step 2: Add the “color” Bucket Property

  • Click on Bucket Properties Tab

  • Click Add

  • Set the Property name to color

  • Write a conditional expression that outputs the “hex code” color value for each performance level in your chart.

For this example, the conditional expression looks like this:

$F{2016-2017 i-Ready Math Diagnostic Overall Relative Placement}.equals("2 or More Levels Below") 
    ? "#EA6F22"
:$F{2016-2017 i-Ready Math Diagnostic Overall Relative Placement}.equals("1 Level Below") 
    ? "#f7a35c"
:$F{2016-2017 i-Ready Math Diagnostic Overall Relative Placement}.equals("On Level")
    ?"#95B3D7"
:$F{2016-2017 i-Ready Math Diagnostic Overall Relative Placement}.equals("Above Level") 
    ? "#366092"
:null

The output for each conditional expression is the “hex code” - a six-digit code that signifies the color you want for each performance level.

Step 3: Add “color” Advanced Property to your Measure

Back on the Chart Configuration screen,

  • Double-click on your Measure

  • Click Advanced Properties tab

  • Click Add

  • Set Contributor to SeriesProperty

  • Set Property Name to color

  • Select Use Bucket Value

  • Choose the .color Bucket Value Property you created

  • Click OK

There are countless websites that will provide the hex code for whatever color you want. For example, .

You’re done! The colors in your chart should now be consistent, no matter how many performance levels are represented in the dataset.

this Color Picker Tool will give you the hex code for whatever color you choose