Skip to main content
{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain="month"
%}
    {% reference_area 
        x_min="2023-11-01" 
        x_max="2024-02-01" 
        label="Peak Season"
        color="green"
    /%}
{% /line_chart %}

​
Examples

​
Highlight Date Range

{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain="month"
%}
    {% reference_area 
        x_min="2023-11-01" 
        x_max="2024-02-01" 
        label="Peak Season"
        color="green"
    /%}
{% /line_chart %}

​
Horizontal Value Band

{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain="month"
%}
    {% reference_area 
        y_min=2500000 
        y_max=4000000 
        label="Target Range"
        color="blue"
    /%}
{% /line_chart %}

​
Areas from Data

```sql seasons
select '2021-01-01' as start_date, '2021-03-31' as end_date, 'Q1' as quarter
union all
select '2021-04-01', '2021-06-30', 'Q2'
union all
select '2021-07-01', '2021-09-30', 'Q3'
union all
select '2021-10-01', '2021-12-31', 'Q4'
```

{% bar_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain="month"
%}
    {% reference_area 
        data="seasons"
        x_min="start_date" 
        x_max="end_date" 
        label="quarter"
    /%}
{% /bar_chart %}

​
Custom Styling

{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain="month"
%}
    {% reference_area 
        y_min=3000000 
        y_max=4500000 
        label="Goal Zone"
        color="green"
        area_options={ 
            border={ width=2 type="dashed" color="green" }
        }
        label_options={
            position="top_right"
            color="green"
        }
    /%}
{% /line_chart %}

​
Attributes

​
data
string
Query name to use for calculating dynamic area boundaries
​
label
string
Text label to display in the reference area
​
x_min
string | number
Left boundary of the area (e.g., a start date)
​
x_max
string | number
Right boundary of the area (e.g., an end date)
​
y_min
string | number
Bottom boundary of the area (e.g., a minimum value)
​
y_max
string | number
Top boundary of the area (e.g., a maximum value)
​
color
string
default:"#0284c7"
Fill color of the reference area
​
label_options
options group
Styling options for the labelExample:
label_options={
  position = "top_left"
  align = "left"
  color = "string"
  background_color = "string"
  padding = 0
  border = { ... }
  text = { ... }
}
Attributes:
  • position: string
    • Allowed values:
      • top_left
      • top
      • top_right
      • bottom_left
      • bottom
      • bottom_right
      • left
      • center
      • right
  • align: string
    • Allowed values:
      • left
      • center
      • right
  • color: string
  • background_color: string
  • padding: number
  • border: options group
  • text: options group
​
area_options
options group
Styling options for the area fill and borderAttributes:
  • color: string
  • opacity: number
  • border: options group

​
Allowed Parents