Set up a "Date bucket" control

“Date bucket” controls let you change the time bucket used for connected charts. Setting up a “Date bucket” control requires two main steps:

Create the “Date bucket” control for your dashboard
Connect the “Date bucket” control to a chart

Create a “Date bucket” control

To add a “Date bucket” control to your dashboard:

Open the dashboard where you want to add the “Date bucket” control.
Select Add control > Date bucket from the dashboard sidebar. A pop-up will appear for you to select the control’s settings.
Optionally, change the Name of the control.
For Default value, select the default time bucket to use when opening the dashboard.
Optionally, select a Background color for your control.
Select Add.
Place the newly created “Date bucket” control anywhere on your dashboard.

Connect a “Date bucket” control to a chart

After you’re created your “Date bucket” control, you’ll need to connect it to a chart in order to start using it to filter. You can do this by using its corresponding dashboard variable in a Visual SQL query.

You can also connect controls in other Visual SQL steps. Learn more about connecting controls outside of a Visual SQL query.

In a visual mode query

To connect a “Date bucket” control to a chart using a visual mode query:

Open the chart editor 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.

Aggregation for 'Created At' column using 'Date bucket' control named DATE_BUCKET

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"')}

Replace DATE_BUCKET_NAME with your control's name.
Make sure to wrap the table-column reference in single quotes.
In your GROUP BY clause, use the same column alias provided in your SELECT statement.

Here’s an example of how someone might connect a “Date bucket” control to the created date of Jira issues:

SELECT {DATE_BUCKET_NAME.BUCKET('"Jira Issue"."created_at"')} AS "Date Bucket of Created At"
FROM "public"."jira _issue" AS "Jira Issue"
GROUP BY "Date Bucket of Created At"

Get the “Date bucket” value

To get the value of your “Date bucket” control, use {DATE_BUCKET_NAME}. The value is returned as an all-lowercase string (for example, day, week, year, etc.). This is useful if you want to perform different calculations that depend on the current value of the “Date bucket” control.