About controls
Let viewers apply filters and set parameter values.
Last updated
Let viewers apply filters and set parameter values.
Last updated
Controls let viewers interact with the data displayed in a Insights report in the following ways:
Viewers can filter the data by specific dimension values.
Viewers set the time frame of the report.
To learn how to filter the data before viewers see it, use a filter property.
Edit your report.
In the toolbar, select
Select the control type, then position on the page.
On the right, use the options in the properties panel to configure the control.
To filter the report by selected dimension values, use a dimension for the Control field.
Controls let viewers filter or change the data displayed in the report's components.
When a control is based on a dimension (you add a dimension from the available fields list as the Control field), the control acts as a filter on the data.
For example, a list control based on the Country dimension let the viewer filter the data by country. An advanced filter based on a Product SKU dimension lets the viewer filter by all or partial part numbers.
More about filters
Controls filter all components on the page based on the same data source as the control itself.
Controls can filter other controls. For example, say you have one filter on the Country dimension, and a second filter on the Campaign dimension. Filtering on Country = France causes the Campaign filter to only show campaigns that ran in France. Similarly, filtering on campaign "ABC" restricts the Country filter to only those countries where that campaign ran.
Controls can only filter by a single dimension. To create a control that filters by more than one dimension, you have several options:
Create multiple filter controls, one for each dimension you want to filter by.
Concatenate the dimension data you want to filter by in a calculated field in the data source.
Concatenate the dimension data you want to filter by in the underlying data, if possible.
Data Source
Provides the dimensions you can use in the control.
Date range dimension
This option appears if your data source has a valid date dimension.
The Date Range Dimension is used as the basis for limiting the date range of the chart. For example, this is the dimension used if you set a date range property for the chart, or if a viewer of the report uses a date range control to limit the time frame.
Dimension
Provides the list of values that appear in the control.
Control field
The dimension to filter by or the parameter whose value is set by this control.
Default selection
Specify default values, separated by commas. Be sure to enter the values exactly as they appear in your data.
Metric
This option displays a reference metric in the control. You can use this to sort the list, however, the viewer can't filter based on a metric value. To hide the metric, uncheck the Show values option.
Decimal precision
Specify the number of digits in the metric value to show.
Order
This option controls the sort order and number of values listed in the control. You can sort the values list in either ascending or descending order by the dimension values, or by the reference metric.
Show top #
This option limits the number of items displayed in the control. If the number of items available exceeds this limit, remaining items are grouped into "All others."
Default Date Range
This option limits the values displayed in the control to the range you specify.
Filter
Restrict the data displayed in the control by including or excluding the values you specify.
Data Source
Provides the dimensions and parameters you can use in the control.
Dimension
Provides the list of values that appear in the control.
Control field
The dimension to filter by or the parameter whose value is set by this control.
Drop-down
Displays the control in a drop-down box.
Fixed-size
Displays the control as a fixed-size box.
Input box auto width
When checked, the entry field's width automatically sizes to fit the available space. To set the entry field's width manually, uncheck this option and enter the desired width in characters.
Label position
Sets the appearance of the control's label.
Search type
Available for controls as filters. Determines the default search operator:
Is. The value exactly matches the search term. (Case sensitive.)
Contains (Default). The value contains the search term.
Starts With. The value begins with the search term.
In. The value matches one or more of the search terms (enter search terms separated by commas).
Label position
Sets the appearance of the control's label.
Search type
Determines the default search operator:
Equals (default). The value exactly matches the search term. (Case sensitive.)
Contains. The value contains the search term.
Starts With. The value begins with the search term.
In. The value matches one or more of the search terms (enter search terms separated by commas).
You can filter by numeric dimensions values using the following operators:
Between. The value is between the starting and ending numbers.
>= The value is greater than or equal to the number.
> The value is greater than the number.
<= The value is less than or equal to the number.
< The value is less than the number.
In. The value matches one or more of the search terms (enter search terms separated by commas)
You can switch an existing control on the report from one type to another:
Edit your report.
Select the control.
On the right, at the top of the properties panel, click on current control name.
Select the new control type.
You may need to edit the control's settings to use the new type.
You can make a control appear in the same location on every page of your report. Filters or parameters set on one page will carry over to all the pages in the report.
Edit your report.
Select the control.
Right click, select Make report-level.
Can't find the control on other pages? It may be underneath other components on the page. Learn more about report-level component position.
