Filters, including bulk filters and exclude filters, can be applied to Liveboards just as with tables and charts. These kinds of filters apply to an entire Liveboard, making it easy to see only the data that you are interested in across the tables and charts within a Liveboard.
|The new Liveboard experience contains multiple new features and feature enhancements. It is on by default, and users can turn it on or off individually from the Experience manager panel in their profile. If you use the classic Liveboard experience in your environment, your experience may be different than the one described in this article.|
Liveboard filters can be very useful when you want to apply the same filters to more than one related visualization. You can narrow the focus of your Liveboard for specific purposes or audiences.
When you apply a filter, the Liveboard is not automatically saved with your filter applied. This is to encourage ad hoc filtering. Therefore, people with read-only access can create Liveboard filters and edit the values of pre-existing filters. You must have edit access to the Liveboard, and view access (or higher) to the underlying data source in order to save a Liveboard filter.
Note that Liveboard filters only apply to the tables and charts that are based on worksheets. If a Liveboard also includes tables and charts that were created from underlying tables or on user uploaded data, the filters don’t apply to them.
To create one filter that filters visualizations based on multiple worksheets, you can link the worksheet columns, at the Liveboard level. Refer to Linked Liveboard filters.
You can create a filter in the Liveboard view for any Liveboard. This allows you to easily manipulate the visualizations and view the modified presentation in one place.
Here is an example that shows you how to add a single filter to a Liveboard. To create a Liveboard filter:
Select the Edit button, and select Add filters. If the Edit button is grayed out, you do not have edit privileges for the Liveboard. To resolve this, contact your administrator or the creator of the Liveboard.
In the populated columns menu, select the Add filter icon next to the column you would like to filter on.
Under Default values > Include, select the values to include in your answer. The filter modal only shows 500 values; if the column you selected has more than 500 values, you must use the filter search bar to find the additional values.
If you want to exclude values, click Exclude and select values to exclude.
When you apply a filter, the Liveboard is not automatically saved with your filter applied to every object in the Liveboard that was created from a worksheet. Liveboard filters do not apply to tables and charts built directly on top of base tables.
You can apply filters to only certain visualizations or tabs that you specify. To specify the visualizations or tabs that a Liveboard filter should apply to, follow these steps, or refer to Selective Liveboard filters:
Select the Edit button at the upper right of the Liveboard. If this button is grayed out, you do not have edit privileges for the Liveboard. To resolve this, contact your administrator or the creator of the Liveboard.
In the top menu bar, select Add filter.
In the Add filters side panel, you see a list of columns. Select the filter icon next to the column you would like to selectively filter on.
Specify values to include or exclude, if you did not already specify them.
Select Applicable to from the filters modal side menu. You can select or unselect entire tabs, or only choose certain visualizations. You can also search for a visualization.
You can link columns from multiple worksheets, to create one Liveboard filter for visualizations that come from different worksheets.
To learn how to create linked filters, refer to Linked Liveboard filters.
Your applied filters appear in a row at the top of the Liveboard, where you can select them to open the filter window. Then, you can edit the values to include or exclude.
If you open the filter modal from View mode, you can only edit the values to include or exclude.
If you open the filter from Edit mode, by selecting the Edit button at the upper right of the Liveboard and clicking on the filter, you can edit the values to include or exclude, specify the visualizations the filter should apply to, and configure linked filters.