Skip to main content
{% radar_chart
    data="demo.daily_orders"
    category="category"
    value="sum(total_sales)"
/%}

Examples

Basic Usage

{% radar_chart
    data="demo.daily_orders"
    category="category"
    value="sum(total_sales)"
/%}

Radar Chart with Multiple Series

{% radar_chart
    data="demo.daily_orders"
    category="category"
    series="year(date)"
    value="sum(total_sales)"
    title="Sales by Category and Year"
/%}

With Custom Colors

{% radar_chart
    data="demo.daily_orders"
    category="category"
    value="sum(total_sales)"
    title="Sales by Category"
    chart_options={
        color_palette = ["#0d0887", "#6300a7", "#a62098", "#d5546e", "#f68d45", "#fcd225", "#f0f921"]
    }
/%}

With Raw ECharts Overrides

{% radar_chart
    data="demo.daily_orders"
    category="category"
    value="sum(total_sales)"
    echarts_series_options={
        lineStyle={ width=3 }
    }
/%}

Attributes

data
string
required
Name of the table or view to query
filters
array
IDs of filters to apply to the query
date_range
options group
Use date_range to filter data for specific time periods. Accepts predefined ranges (e.g., “last 12 months”), dynamic ranges (e.g., “Last 90 days”), custom date ranges (e.g., “2020-01-01 to 2023-03-01”), or partial ranges (e.g., “from 2020-01-01”, “until 2023-03-01”)Example:
date_range={
  range = "today"
  date = "string"
}
Attributes:
  • range: string - Time period to filter. Use presets like ‘last 7 days’, dynamic patterns like ‘Last 90 days’, custom ranges like ‘2020-01-01 to 2023-03-01’, or partial ranges like ‘from 2020-01-01’.
    • Allowed values:
      • today
      • yesterday
      • last 7 days
      • last 30 days
      • last 3 months
      • last 6 months
      • last 12 months
      • previous week
      • previous month
      • previous quarter
      • previous year
      • this week
      • this month
      • this quarter
      • this year
      • next week
      • next month
      • next quarter
      • next year
      • week to date
      • month to date
      • quarter to date
      • year to date
      • all time
  • date: string - Date column to filter on. Required when the data has multiple date columns.
category
string
required
Column name for categories (one radar axis per category)
series
string
Column name for series grouping (one polygon per series)
value
string
required
Column name for values (distance from center on each axis)
title
string
Title to display above the component
subtitle
string
Subtitle to display below the title
info
string
Information tooltip text (can only be used with title). Displays an info icon next to the title.
URL to link the info text to (can only be used with info)
Create a custom link title for the info link, placed after the info text (can only be used with info_link)
value_fmt
string
default:"num"
Format for values. See Value Formatting for available formats.
max
number
Maximum value for the radar axes (defaults to the largest value in the data)
shape
string
default:"polygon"
Shape of the radar gridAllowed values:
  • polygon
  • circle
fill
boolean
default:"true"
Fill the area enclosed by each series
show_values
boolean
default:"false"
Show formatted values at each point
legend
boolean
Show legend for series (defaults to true when series is provided, false otherwise)
legend_location
string
default:"top"
Position of the legend (top or bottom)Allowed values:
  • top
  • bottom
chart_options
options group
Chart configuration optionsExample:
chart_options={
  color_palette = ["value1", "value2"]
  series_colors = {
    "key1" = "value1"
    "key2" = "value2"
  }
}
Attributes:
  • color_palette: array of strings
  • series_colors: map of key-value pairs
echarts_options
map
Raw ECharts options deep-merged over the chart’s final configuration. Use for anything the structured props do not expose — graphic, visualMap, tooltip styling, and so on. Partial overrides win key-by-key without clobbering Studio’s computed siblings. For overrides scoped to the data series, use echarts_series_options.Example:
echarts_options={
    tooltip={ position="top" }
    graphic=[{ type="text" }]
}
echarts_series_options
map
Raw ECharts series options deep-merged into the chart series. Use for series-level styling the structured props do not expose.Example:
echarts_series_options={
    itemStyle={ borderRadius=8 }
}
refresh_interval
number
Time in seconds between automatic data refreshes (minimum 60). Overrides the page-level auto-refresh setting for this component.
where
string
Custom SQL WHERE condition to apply to the query. For date filters, use date_range instead.
having
string
Custom SQL HAVING condition to apply to the query after GROUP BY
limit
number
Maximum number of rows to return from the query. Note: When used with tables, limit will disable subtotals to prevent incomplete subtotal rows.
order
string
Column name(s) with optional direction (e.g. “column_name”, “column_name desc”)
qualify
string
Custom SQL QUALIFY condition to filter windowed results
width
number
Set the width of this component (in percent) relative to the page width
height
number
Set a fixed height for the chart in pixels
connect_group
string
Link this chart to others sharing the same id, syncing their tooltips, axis-pointer, and zoom