Skip to main content

Configuring Reports, Pages, and Charts (and How Filters Work Together)

Learn where to configure a whole report, a single page, or one chart, and how page filters and chart filters combine.

Written by Chelsie Pettit

Reports in Crelate have three levels you can configure: the whole report, a page within it, and a single chart. Each level has its own button, and settings at one level don't change the others.

Only a report's owners and Admins can save changes to a report. Other users can explore a report and use Save a copy of report as to keep their own copy.

Where to configure

Configure the whole report

A report is a tab across the top of Reports, such as Candidates or Placements. Select the report's tab, then select Configure Report at the top right, next to Export. From here you can:

  • Save a copy of the report

  • Rename or delete the report

  • Manage Sharing and ownership

  • Add the report to your Favorites

  • Move the report left or right in the tab order

Configure a page

Each report has pages, shown as the row of sub-tabs under the report name, such as Overview or By Stage. Select the page, then select the gear icon to the left of Filters to open Configure Page. From here you can:

  • Add charts or tables to the page

  • Rename, duplicate, delete, or move the page

  • Configure scheduled emails for the page

  • Set up Quick Filters and Display Options

  • Choose which user roles can see the page

  • See and manage the charts on the page

Add page filters

Page filters apply to every chart on the page. Select Filters on the page row, then select Add filter. The Filters button shows how many page filters are active.

Configure a chart

Each chart has its own icons at its top right:

  • The gear icon opens Configure Chart on the Settings tab. Change what the chart measures, its rows and columns, its presentation (for example, Donut, Pyramid, or Pivot grid), and its title.

  • The filter icon opens Configure Chart on the Filters tab, where you add filters for that chart only.

Changes apply only to that chart.


How page filters and chart filters work together

Page filters and chart filters always work together as AND. The page filter is applied first, and any chart filters are applied in addition to it. A chart filter can narrow results further, but it can't show records that the page filter excludes.

Example: A page has a page filter of Owner is Jane. One chart on the page has a chart filter of Created this month. That chart shows only records owned by Jane and created this month.

Page filters also apply to the type of record each chart counts. For example, on a page with both Candidate and Job charts, each chart applies the page filter to its own records.

Tips

  • If a chart shows fewer records than you expect, check the page filters first. The Filters button shows how many are active.

  • Use a page filter for anything every chart on the page should share, such as a date range or owner. Use a chart filter for anything only one chart needs.


How do I choose how chart filters combine?

When a chart has more than one filter, Match at the top of the Filters tab controls how they combine. All shows records that match every filter. Any shows records that match at least one filter.

  1. On the chart, select the filter icon at the top right. Configure Chart opens on the Filters tab.

  2. Next to Match, select All or Any.

  3. Select OK.

  4. Select the green Save button at the top of the report page.


What do the And, Or, and And not operators do?

Once you select Any, an operator drop-down appears between filters so you can choose how each filter connects to the one above it:

  • And shows records that match both filters.

  • Or shows records that match either filter.

  • And not shows records that match the filter above and excludes records that match the filter below.

Example: A chart has a When filter set to This Month and a Who filter for one user. With And not between them, the chart shows this month’s records for everyone except that user.


How do I exclude records from a report?

You can exclude records with the And not operator. It appears in the operator drop-down between filters after you select Any next to Match.

  1. On the chart, select the filter icon at the top right. Configure Chart opens on the Filters tab.

  2. Add the filter for the records you want to include, such as a date range.

  3. Select Add filter and add a filter for the records you want to exclude, such as specific users or Companies.

  4. Next to Match, select Any.

  5. Select the operator drop-down between the two filters, then select And not. The operator changes to AND NOT.

  6. Select OK.

  7. Select the green Save button at the top of the report page.

💡 Pro Tip: If you do not see And not, select Any next to Match first. Report filters work differently from Advanced Search, so the Advanced Search steps for excluding records do not apply to reports.


FAQs

Why does my chart show fewer records than its chart filter suggests?

The page filter is applied first. Your chart only shows records that match both the page filter and the chart filter. Select Filters on the page row to see which page filters are active.

Can a chart filter override a page filter?

No. Chart filters are always added on top of page filters. To show different data, change or remove the page filter, or move the chart to another page.

I changed a setting, but it only affected one chart. Why?

You likely changed it in Configure Chart, which affects only that chart. To change a whole page, use the gear icon next to Filters or the Filters button. To change the whole report, use Configure Report.

Why can't I save my changes?

Only a report's owners and Admins can save changes. Use Save a copy of report as in Configure Report to keep your own copy, or ask an Admin to make you an owner.

Why do I not see And not in my chart filters?

The And not operator appears in the drop-down between filters after you select Any next to Match. Select Any, then select the operator between the two filters and choose And not.

Why is neither All nor Any selected after I changed an operator?

When you choose your own operators between filters, such as And not, Match no longer shows All or Any as selected, because the filters now use the combination you chose.

Why did my filter change not stay?

Selecting OK applies the change to the chart, but you also need to select the green Save button at the top of the report page. Only a report’s owners and Admins can save changes. Other users can use Save a copy of report as in Configure Report to keep their own copy.


What's Next?

Did this answer your question?