...
To connect a “Calendar” control to a chart using a visual mode query:
Open the chart builder editor by creating a new chart or editing an existing chart on the dashboard.
In the “Filters” section of your visual mode query:
Add the date column you want the control to filter.
Select the filter operator. Most people use between and including.
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.
Select Run query. The result table will update with the new filter applied to the data.
Select Save to dashboard to save the chart.
...