Creating a bullet chart with the Chart Config Editor

Bullet charts are useful for showing performance against a target, or progress on a goal.

Using the Chart Config Editor , you can create bullet charts by starting from a bar chart in Looker.

For example, the following bullet chart compares the New Customers Countmeasure, represented by a blue progress bar, to a target value of 40, represented by a blue vertical line. The chart also indicates progress buckets between 0 and 20, between 20 and 40, and between 40 and 80, each represented by a different shade of grey.

Prerequisites

To access the Chart Config Editor, you must have the can_override_vis_config permission .

Writing the JSON snippet

To create a bullet chart, start from the following JSON snippet:

  { 
  
 char 
 t 
 : 
  
 { 
  
 t 
 ype 
 : 
  
 'bulle 
 t 
 ' 
  
 }, 
  
 xAxis 
 : 
  
 { 
  
 ca 
 te 
 gories 
 : 
  
 [ 
 'New 
  
 Cus 
 t 
 omers' 
 ] 
  
 }, 
  
 yAxis 
 : 
  
 { 
  
 plo 
 t 
 Ba 
 n 
 ds 
 : 
  
 [{ 
  
 fr 
 om 
 : 
  
 0 
 , 
  
 t 
 o 
 : 
  
 20 
 , 
  
 color 
 : 
  
 '# 
 666666 
 ' 
  
 }, 
  
 { 
  
 fr 
 om 
 : 
  
 20 
 , 
  
 t 
 o 
 : 
  
 40 
 , 
  
 color 
 : 
  
 '# 
 999999 
 ' 
  
 }, 
  
 { 
  
 fr 
 om 
 : 
  
 40 
 , 
  
 t 
 o 
 : 
  
 80 
 , 
  
 color 
 : 
  
 '#bbbbbb' 
  
 }], 
  
 }, 
  
 series 
 : 
  
 [{ 
  
 da 
 ta 
 : 
  
 [{ 
  
 tar 
 ge 
 t 
 : 
  
 40 
  
 }] 
  
 }], 
 } 
 

Change the following values to fit your use case:

• The xAxis.categories attribute overwrites the label of the X-axis. In this example, the X-axis label should be the measure name New Customers.
• The yAxis.plotBands attribute specifies the background color of the chart for certain values. In this example, the background color is dark grey ( #666666 ) between 0 and 20, medium grey ( #999999 ) between 20 and 40, and light grey ( #bbbbbb ) between 40 and 80.
• The series.data.target attribute specifies the target value for the bullet chart, which will appear as a vertical line. In this example, the target is 40.

Creating a bullet chart

To create a bullet chart, follow these steps:

1. View a bar chart in an Explore, or edit a bar chart in a Look or dashboard.

   For this example, we recommend starting from a bar chart with one dimension and one measure, with a limit of one row. Your starting chart might look something like this example:

   

2. Open the Editmenu in the visualization.

3. In the Plottab, click the Edit Chart Configbutton. Looker displays the Edit Chart Configdialog.

4. Select the Chart Config (Override)section, and enter the HighCharts JSON from the Writing the JSON snippet section of this page.

5. To allow Looker to properly format your JSON, click <> (Format code).

6. To test your changes, click Preview.

7. To apply your changes, click Apply. The visualization will be displayed using the custom JSON values.

Once you've customized your visualization, you can save it. If you viewed the visualization in an Explore, save the Explore . If you edited a Look or a dashboard, click Save.