Add another layer of customization to your reports with filters. They’re an optional feature to help you sort your data. This article will explain how to apply and use filters on your reports. You’ll also learn how to create your own filters.
NOTE: To clearly explain filters, let’s navigate to the same report on your Report Center: the pre-built time-tracking report. Follow the steps below to get to this report and to learn all about filters.
Apply and Use Filters to Your Report
1. Click ANALYTICS...REPORT CENTER from your navigation bar.
2. Click VIEW REPORT under the TIME TRACKING tile.
3. Click the FUNNEL ICON located on your utility bar, which is near the top-right of your window—to add filters to each of your columns.
4. Click on a filter in a specific column to filter it. For example, say you want to filter the Week Ending column. When you click on the filter icon, a calendar populates where you can add parameters by selecting date ranges.
Then, click APPLY to apply your changes, and the report will populate with new results based on the parameters.
To remove the column filter parameters and restore your column data, click on the FILTER ICON on the column and click CLEAR. The red-colored filter indicates the column with an active filter.
Remove filters from your columns entirely by re-clicking on the filter icon on your utility bar.
Create Custom Filters
Custom filters are ideal when you want a report to include or exclude certain criteria. Follow the steps below.
1. Click CUSTOMIZE, which is near the top-right of your window, and then, click Customize from the picklist that populates.
These actions will take you to your REPORT WIZARD.
2. Click OPTIONS, which is near the top-right of your window, and then select CUSTOMIZE FILTERING from the picklist.
3. Add custom filters: set criteria based on a relationship between one value to another by choosing a comparison value.
Here’s an example:
Given the selections above, the report will pull all time entries that have been logged to the ‘Administrative’ category.
4. Click UPDATE REPORT to save your work.
Note: When using a comparison such as Equals the value must be the exact name. If they want to be a little bit more general, use Contains instead.