Use a Range Input to filter a chart

Variables

Chartio has multiple Dashboard Variables which can be used to filter your chart data such as the Date Slider to dynamically filter charts by date. We also have a Range Input which can help you filter your charts by a numeric range. This variable can be used in various types of charts.

For this example, we’ll use the Range Input to filter results on a Map chart. The Map below shows meteorite hits across the world (data courtesy of NASA).

Map chart without filter

There is a large range in the mass of the meteorites, ranging from 0.1 grams to 3,000,000 grams. To view areas within a more specific range, you can filter out some of the data using a Range Input as a filter on your dashboard.

From your dashboard’s side menu, click Add Control and select Range Input from the options.

Add a Range Input control to your dashboard

A modal will pop up for you to customize your variable settings.

Select the desired Min and Max for your range.

Next, edit the Precision if you would like to include all values or if you would like to bucket the range input values. For example, using a precision of 5 will allow you to select range values in increments of 5. Here, we want all values so we’ll set our range input to the lowest precision option of 1.

Finally, set the range for the Default values that will be selected when the dashboard is first loaded. Click Ok.

Fill our the Range Input

The modal will then turn into a Range Input which can be placed anywhere on your dashboard.

Next, you’ll need to set this as a filter in your chart(s) to connect your chart to the Range Input. Open your chart by clicking Edit Chart Data from the chart’s ellipsis menu. Then add the column with the range you’d like to use as a filter to the Filters box.

Set the filter to between and including and select your Range Input from the start and end dropdown options. Chartio will be able to detect the Range Input variable based on the name specified.

Click Ok and save your chart.

Add Range Input as a Filter to your chart

Your chart will now dynamically filter according to the range’s selection. Adjust the start and end of the range by dragging the start and end circle on your control on the dashboard.

The chart now dynamically reacts


Related Variables Help Articles

See more