Versions Compared

Key

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

...

To connect a “Calendar” control to a chart using a visual mode query:

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

      • If the “Data type” of your control is “Date”, use {CALENDAR_NAME}

      • If the “Data type” of your control is “Date range”, use {CALENDAR_NAME.START} and {CALENDAR_NAME.END} for the start and end dates, respectively.

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

...