Filtering data in a report

You can decide which data is displayed in the report by selecting whether the data is pulled directly from your primary organization or from a specific scenario. You can also apply additional filters to further refine the data that displays in your report.

When you add a filter to report data, that filter is applied to all charts (when they are not enabled to ignore report filters). Filters are applied only in that instance and are not saved permanently. To save a filter, you must enter it into the Saved filter dropdown. Learn more.

To filter the data in a report: 

1. From the left sidebar, select Reports. 
2. Open the report you want to customize. 
3. In the Scenario dropdown, select the data set used in the report. You can select from the following options:
   • Primary, no forecast – Calculates the report using data from your primary organization. 
   • Primary, with hiring forecast – Calculates the report using data from your primary organization, including projections based on new hires. 
   • User’s Scenario - Calculates the report using data based on a specific user’s scenario proposal. Only scenarios you have permission to view display in the list. Learn more. 
   • Compensation review - Calculates the report using data from the selected compensation review. Only compensation reviews you have permission to view display in the list. Learn more. 
4. The Time interval dropdown, allows you to select how time is grouped together in the report. You can select from the following options:
   • Week
   • Month
   • Quarter
   • Year
   • Fiscal quarter
   • Fiscal year
5. In the Date range dropdown, select a date range for the report. The date ranges are based on the time interval you selected. 
   • Alternatively, you can enter a custom date range by clicking on the listed dates.
6. Choose your filter options in the Filters dropdown menu or enter a Carrot (CQL) query directly in the query box. 

The report filters you apply are only applied in the immediate instance and are not saved. However, you can save a filter so that you can easily apply it whenever you access your report.

To save a filter: 

1. From the left sidebar, select Reports. 
2. Open the report you want to view. 
3. Select the Saved filter ▼ dropdown in the top right section.
4. Enter the Carrot (CQL) query directly into the text box.
5. Select Save.
   • Your filter is saved as an option in the dropdown list. 
   • When you access the report again, you can select it from the dropdown and apply it without having to enter it again manually.

You have the option to filter data at the chart level. Chart level filters are maintained and do not have to be reapplied. 

To filter the data in a chart:

1. From the left sidebar, select Reports. 
2. Open the report you want to customize. 
3. Select the ⋮ menu for the chart you want to filter.
4. Select Edit.
5. Choose your filter options for the chart in the Filters dropdown menu or enter a Carrot (CQL) query directly in the query box.
   • You can choose to ignore the report-level filters by enabling the Ignore report filters option.
   • Select the Filter icon to test how your filters affect the data in the chart.
6. Select Save & exit.