Filter pane

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. For example, if you have a chart of sales over time, you can use a filter pane to limit the data in the chart to only show sales from a selected time period, from certain product categories, and from a certain region.

When a dimension is added, it is placed to the right of the previous dimensions, or below, depending on the available space. As long as there is space enough, the dimensions are displayed as expanded lists. If there is not enough space, the dimensions that were added first are turned into filter panes.

Responsive design

The filter pane has a responsive design and renders as many dimensions as possible. When space is limited, this could involve reducing the size of each dimension so that all dimensions are displayed.

Example:  

The following image shows a filter pane while it is being edited. Only three out of five dimensions are displayed. The other dimensions are replaced by a button with an ellipsis (...), indicating that there are more dimensions that are not displayed. You can click the button to open the filter pane in full screen view.

When you have finished editing the filter pane and enter analysis mode, you will see the filter pane with all the dimensions displayed. If all items cannot be shown due to lack of space, the ellipsis box is displayed to indicate that there are more dimensions.

Full screen view

In full screen view, the filter pane is maximized and displays as many dimensions as possible expanded. When not all dimensions can be displayed expanded, the priority order is that the most recently added dimensions are expanded to the right. You can change the priority order in the properties panel, under Dimensions. Drag the dimensions to change the order.

Full screen view on a touch device

Do the following:

1. Long-touch the visualization.

   The touch item menu is displayed.

2. Tap s.

The visualization is displayed in full screen.

Close the full screen view and return to the sheet view by clicking E.

Full screen view on a computer (mouse interaction)

By default the full screen icon is hidden.

Do the following:

1. Hover over the visualization that you want to expand.

2. Click s at the top right of the visualization.

The visualization is displayed in full screen.

Close the full screen view and return to the sheet view by clicking E.