...
Open the chart builder by creating a new chart or editing an existing chart on the dashboard. You’ll need a chart containing a date or datetime column.
Edit the visual mode query containing the date or datetime column.
Open the column’s aggregation menu then select your “Date bucket” control’s name.
Select Run query. The result table will update with the new filter applied to the data.
Select Save to dashboard to save the chart.
...
In a SQL mode query
You can connect a “Date bucket” control in your SQL query by using the following format to reference the control: {DATE_BUCKET_NAME.BUCKET('"table_name"."column_name"')}
...