Skip to main content
Using date_grain 
{% date_grain_selector
    id="time_grain"
    default_value="month"
/%}

{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain={{time_grain}}
/%}

​
Examples

​
Using date_grain

Using date_grain 
{% date_grain_selector
    id="time_grain"
    default_value="month"
/%}

{% line_chart
    data="demo_daily_orders"
    x="date"
    y="sum(total_sales)"
    date_grain={{time_grain}}
/%}

​
Using Inline SQL

{% date_grain_selector
    id="time_grain"
    default_value="month"
/%}

```sql sales_by_period
select 
    date_trunc({{time_grain}}, date) as period,
    sum(total_sales) as total_sales
from demo_daily_orders
group by 1
order by 1
```

{% line_chart
    data="sales_by_period"
    x="period"
    y="total_sales"
/%}

​
Attributes

​
id
string
required
The id of the date grain selector to be used in SQL query templates
​
preset_values
array
Optional array of preset date grain values to show. If not provided, all date grain options will be available.
​
default_value
string
Default date grain to select on loadAllowed values:
  • day
  • week
  • month
  • quarter
  • year
  • hour
  • day of week
  • day of month
  • day of year
  • week of year
  • month of year
  • quarter of year
​
title
string
default:"Date Grain"
Text displayed above the selector
​
info
string
Information tooltip text
​
info_link
string
URL to link the info text to (can only be used with info)
​
info_link_title
string
Create a custom link title for the info link, placed after the info text (can only be used with info_link)
​
placeholder
string
Placeholder text displayed when no value is selected
​
icon
string
default:"clock"
Icon to display
​
width
number
Set the width of this component (in percent) relative to the page width

​
Using the Filter Variable

Reference this filter using {{filter_id}}. The value returned depends on where you use it.
ContextDefault PropertyNo SelectionResult
Inline SQL query.selected'''month'
where attribute.selected'''month'
Text / Markdown.literalmonth

​
Available Properties

You can also access specific properties using {{filter_id.property}}:

​
.selected

Returns the selected date grain value with quotes. Returns an empty string when no value is selected. 
{% date_grain_selector id="grain" preset_values=["day", "week", "month"] /%}

```sql sales_by_grain
select 
  toStartOf{{grain.selected}}(date) as period,
  sum(sales) as total_sales
from orders
group by period
```
Example value: 'month'

​
.literal

Returns the raw unescaped selected value. Use this with the date_grain attribute. 
{% date_grain_selector id="grain" preset_values=["day", "week", "month"] /%}

```sql sales_by_grain
select 
  {{grain.literal}} as period,
  sum(sales) as total_sales
from orders
group by period
```
Example value: month