Versions Compared

Key

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

...

  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.

...

In a SQL mode query

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

...