All Collections
Reporting
Copper Reports
Reports Dashboards: Filtering Reports, Dashboards, and Insights
Reports Dashboards: Filtering Reports, Dashboards, and Insights

Reports Dashboards: Filtering Reports, Dashboards, and Insights

Success at Copper avatar
Written by Success at Copper
Updated over a week ago
ProBiz.png

Filtering is a powerful tool to key in on exactly the information you are looking for. In Reports, there are several layers of filtering that you can leverage to customize your experience.

Dashboard Filters

Dashboard filters allow you to apply filters over an entire Dashboard.

Screen_Shot_2021-03-22_at_2.36.07_PM.png

To apply a Dashboard filter:

  1. Open the Dashboard

  2. Below the Dashboard title, you’ll see a range of filter options. Click on the aspect you’d like to filter on and select your filter criteria.

  3. Click Apply.

  4. Your Dashboard will automatically refresh and repopulate itself to match your filters.

You can apply multiple Dashboard filters to narrow down your view even further.

Note: if a Dashboard filter is applied while you export a Dashboard or schedule an email, that filter will be reflected in the PDF export.

Overriding Dashboard Filters on Insights

Normally, Dashboard filters apply to all Insights on a Dashboard. However, you can adjust individual Insights on a Dashboard so that they will not be affected by a Dashboard filter.

To override a dashboard filter on an Insight:

  1. Open the applicable Dashboard and click the Edit button in the top right corner.

  2. Select the applicable Insight and click on the three dots [...] on in the top right corner.

    Screen_Shot_2021-03-24_at_3.54.30_PM.png
  3. A configuration window will appear. Click on Configuration and select which types of Dashboard filters you would like to apply to this Insight.

    Screen_Shot_2021-03-24_at_3.56.22_PM.png

Insight Filters

There are two types of filters you can apply to individual Insights:

  1. Topline filters: these change the data range you’re currently viewing in the Insight, but does not change the configuration of the Insight itself.

  2. Measure filters: these change the core data available to Insight.

Top Line Filters on Insights

Top Line filters allow you to filter information that’s currently displayed on an Insight.

Screen_Shot_2021-03-23_at_11.28.50_AM.png

To apply a top line filter to an Insight:

  1. Open an individual Insight in edit mode.

  2. Below the Insight title, you’ll see a range of filter options. Click on the aspect you’d like to filter on and select your filter criteria.

  3. Click Apply.

  4. Your Dashboard will automatically refresh and repopulate itself to match your filters.

Please note that top line filters are meant to offer a temporary view, meaning they will reset each time you load the Insight. If the Insight is on a Dashboard, it will also be affected by any dashboard filter you apply.

If you are hoping to apply a permanent filter to an Insight, please read below to learn about measure filters.

Measure Filters on Insights

Measure filters are useful if you need an Insight to look only at a specific range of data. They change the underlying data that is available to the Insight, whereas a top line filter will only change your temporary view.

Screen_Shot_2021-03-24_at_1.18.34_PM.png

To apply a measure filter:

  1. First, open an Insight in editing mode.

  2. Make sure you have at least one piece of data in the Measures section. Click on the arrow icon beside the measure you would like to filter on.

    Screen_Shot_2021-03-24_at_1.21.22_PM.png
  3. Click on +Add attribute filter or on one of the other filter options.

    Screen_Shot_2021-03-24_at_1.25.43_PM.png
Did this answer your question?