You can add a filter pane to control what data that is shown in the visualizations on a sheet. A filter pane can filter the data of several dimensions at once.
You can create a filter pane on the sheet you are editing.
In a filter pane you can use up to 1000 dimensions.
Do the following:
- In a sheet, click
to add a new visualization. - Under Visualization, select Filter pane.
- Click and drag a field or master dimension under Data. You can add multiple dimensions to a filter pane.
When you have created the filter pane, you may want to adjust its appearance and other settings in the properties panel.
Each field in the filter pane will have its own listbox, which will show the individual field values. Each listbox in a filter pane can be customized with its own unique properties. To customize a listbox, you need to turn on the Advanced options when editing the sheet.
Configuring search options
In the Listbox properties, you can choose whether or not users can search for individual field values in each listbox within the filter pane. You can also switch the default Search mode from Normal to Wildcard. Wildcard adds default wildcard symbols (*) to the search field.
Condensing information in the filter pane
To remove extra space between each dimension value, select the Compact view checkbox under Presentation in the advanced properties for each listbox.
Changing selection behavior
If you select Checkbox mode under Presentation, the listbox for that field will switch to a view in which each dimension value is represented by a checkbox. In this mode, selections are made by clicking the checkbox next to each item, rather than the default behavior allowing clicking and dragging to select multiple values at once.
Displaying dimension value frequencies
Under Presentation for a listbox, click the checkbox next to Histogram to display bars underneath each dimension value to represent how frequently each value appears in the data.
Switching to grid layout
By default, a listbox for a field in a filter pane will be set to show data in a single column. Alternatively, you can show data in a grid layout. Under Presentation, switch the parameter for Show data in from Single column to Grid.
In the grid layout, you can also configure how the data is ordered (by Row or Column), and customize the maximum visible rows or columns in the grid.
Showing the frequency of values
You can show the frequency next to each value, either as an absolute number or as a percentage. You select this by clicking the field in the properties panel, then clicking Presentation > Show frequency.