Set up a "Range input" control

“Range input” controls let you filter your data based on a selected numeric range. Setting up a “Range input” control requires two main steps:

1. Create the “Range input” control for your dashboard

2. Connect the “Range input” control to a chart

Create a “Range input” control

To add a “Range input” control to your dashboard:

1. Open the dashboard where you want to add the “Range input” control.

2. Select Add control > Range input from the dashboard sidebar. A pop-up will appear for you to select the control’s settings.

3. Edit the control’s settings as needed. (See next section to learn more about “Range input” settings)

4. Select Add.

5. Place the newly created “Range input” control anywhere on your dashboard.

“Range input” control settings

You can edit the following settings for your “Range input”:

Name

The control’s name

Min

The minimum value for the control’s range

Max

The maximum value for the control’s range

Precision

Enforces increments when selecting values in the range

Default values

Set default values to select when you load the dashboard

Connect a “Range input” control to a chart

After you’re created your “Range input” 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.

In a visual mode query

To connect a “Range input” 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 numeric column you want the control to filter.

   2. Select between and including as the filter operator.

   3. Reference your control using its variable:

      • Use {RANGE_INPUT_NAME.START} for the beginning of the range.

      • Use {RANGE_INPUT_NAME.END} for the end of the range.

      • Replace RANGE_INPUT_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.

Open

In a SQL mode query

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

• Use {RANGE_INPUT_NAME.START} for the beginning of the range.

• Use {RANGE_INPUT_NAME.END} for the end of the range.

Replace RANGE_INPUT_NAME with your control's name.

Here’s an example of how someone might get a list of Jira issue IDs where the total amount of logged work is between the selected values of a “Range input” control: