Range Calendar

{% range_calendar
    id="date_filter"
/%}

```sql ranged_query
select * 
from demo_daily_orders
[[where date {{date_filter.between}}]]
```


{% big_value
    data="ranged_query"
    value="sum(total_sales)"
/%}

{% range_calendar
    id="date_filter"
    title="Sales Period"
    preset_ranges=["last 7 days", "last 30 days", "month to date", "quarter to date", "all time"]
    default_range="month to date"
/%}

```sql filtered_sales
select * 
from demo_daily_orders
[[where date {{date_filter.between}}]]
```

{% big_value
    data="filtered_sales"
    value="sum(total_sales)"
/%}

{% range_calendar
    id="recent_filter"
    title="Recent Activity"
    preset_ranges=["last 7 days", "last 30 days", "month to date"]
/%}

<!-- Since "all time" is not in preset_ranges and no default is specified,
     this will automatically default to "last 7 days" (the first preset) -->

```sql recent_orders
select * 
from demo_daily_orders
[[where date {{recent_filter.between}}]]
```

{% big_value
    data="recent_orders"
    value="count(*)"
    title="Recent Orders"
/%}