Creating a streamgraph chart with the Chart Config Editor

A streamgraph chart is a type of stacked area chart that is useful for displaying compound volume across different categories or over time.

Using the Chart Config Editor , you can create streamgraph charts by starting from an area chart in Looker. Streamgraph charts require two dimensions and one measure.

For example, the following streamgraph chart shows the Total Sale Priceover several different Categoryvalues, plotted over Order Created Month. Categories are stacked on top of one another to show how much each category contributes to the total, as well as how the total changes over time.

Prerequisites

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

Writing the JSON snippet

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

  { 
  
 char 
 t 
 : 
  
 { 
  
 t 
 ype 
 : 
  
 's 
 trea 
 mgraph' 
 , 
  
 } 
 } 
 

Creating a streamgraph chart

To create a streamgraph chart, follow these steps:

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

   For this example, we recommend starting from an area chart with two dimensions and one measure. One dimension should be pivoted. 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 let Looker 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.