Versions Compared

Version Old Version 2 New Version 3
Changes made by

Cat Africa

Cat Africa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Tip

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

...

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

...