/
Set up a "Date slider" control
Our documentation has moved!

Our documentation now lives on the Atlassian Support site at https://support.atlassian.com/analytics/resources/.

Set up a "Date slider" control

Owned by Cat Africa
Last updated: Jun 15, 2022
2 min read

“Date slider” controls let you focus on a specific date range for your data.

Setting up a “Date slider” control requires two main steps:

  1. Create the “Date slider” control for your dashboard

  2. Connect the “Date slider” control to a chart

Create a “Date slider” control

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

  1. Open the dashboard where you want to add the “Date slider” control.

  2. Select Add control > Date slider from the dashboard sidebar. This takes you to the control editor, which is similar to the chart editor. You’ll use Visual SQL to create your “Date slider” control, but instead of a chart preview, you can preview your “Date slider” control.

  3. Add a date column to the “Columns” section of the query. You can also add a numeric column to make a 2D “Date slider” control.

  4. Select Run query. The preview pane will display the control’s settings.

  5. Optionally, change the Name of the control.

  6. Edit the Default start and end dates using fixed dates, or use a combination of relative date variables and datetime functions for dynamic filtering.

  7. Optionally, select a Background color for your control.

  8. Select Save to dashboard.

  9. Place the newly created “Date slider” control anywhere on your dashboard.

Connect a “Date slider” control to a chart

After you’re created your “Date slider” 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 slider” control to a chart using a visual mode query:

  1. Open the chart editor by creating a new chart or editing an existing chart on the dashboard.

  2. In the “Filters” section of your visual mode query:

    1. Add the date column you want the control to filter.

    2. Select the filter operator. Most people use between and including.

    3. Reference your control using its variable:

      1. Use {DATE_SLIDER_NAME.START} for the start date.

      2. Use {DATE_SLIDER_NAME.END} for the end date.

      3. Replace DATE_SLIDER_NAME with your control's name.

  3. Select Run query. The result table will update with the new filter applied to the data.

  4. Select Save to dashboard to save the chart.

Filter condition using 'Date slider' control named DATE_SLIDER

In a SQL mode query

You can connect a “Date slider” control in your SQL query by referencing the control using its variable:

  • Use {DATE_SLIDER_NAME.START} for the start date.

  • Use {DATE_SLIDER_NAME.END} for the end date.

Replace DATE_SLIDER_NAME with your control's name.

Here’s an example of how someone might get the total number of Jira issues created between the selected dates of a “Date slider” control:

SELECT COUNT(DISTINCT "Jira Issue"."issue_id") AS "Count of distinct Issue Id" FROM "public"."jira _issue" AS "Jira Issue" WHERE "Jira Issue"."created_at" BETWEEN {DATE_SLIDER_NAME.START} AND {DATE_SLIDER_NAME.END};

 

Related content