Pinboard filters

You can apply filters to Pinboards as well as tables and charts.

Filters, including bulk filters and exclude filters, can be applied to Pinboards just as with tables and charts. These kinds of filters apply to an entire Pinboard, making it easy to see only the data that you are interested in across the tables and charts within a Pinboard.

When to use a pinboard filter

Pinboard 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 Pinboard for specific purposes or audiences.

When you apply a filter, the Pinboard is not automatically saved with your filter applied. This is to encourage ad hoc filtering. Therefore, people with read-only access can create Pinboard filters. You must have edit access to the Pinboard, and view access (or higher) to the underlying data source in order to save a Pinboard filter.

Note that Pinboard filters only apply to the tables and charts that are based on Worksheets. If a Pinboard also includes tables and charts that were created from underlying tables or on user uploaded data, the filters don’t apply to them.

Create a pinboard filter

You can create a filter in the Pinboard view for any Pinboard. 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 Pinboard. To create a Pinboard filter:

  1. Click the More icon more options menu icon, and select Add filters.

    add pinboard filters
  2. In the populated columns menu, click the Add filter icon next to the column you would like to filter on.

    add filters menu
  3. Select the values to include in your Answer.

    column filter
  4. If you want to exclude values, click Exclude and choose values to exclude.

    exclude nulls
  5. Click Done.

When you apply a filter, the Pinboard is not automatically saved with your filter applied to every object in the Pinboard that was created from a Worksheet. Pinboard filters do not apply to tables and charts built directly on top of base tables.

Edit a filter from the answer

Your applied filter will sit at the top of the Pinboard, where you can edit it in place:

select filters

Or delete it:

filter appears