website logo
ChartHop documentation
Carrot reference
Release notes
Navigate through spaces
ChartHop documentation
Carrot reference
Release notes
⌘K
Welcome
Welcome to ChartHop documentation🚀
Available ChartHop packages
Getting Started
ChartHop Video Library
Navigating ChartHop
ChartHop terminology
Markdown formatting
Filtering data
Home page
Visualizing your organization
Org Chart
Map
Data Sheet
Employee Profiles
Setting up ChartHop
Creating your ChartHop org
Importing spreadsheet data
Configuring your Org settings
User management
Permissions and security
Creating and managing groups
Customizing ChartHop
Forms
Fields
Customizing employee profiles
Document templates
ChartHop apps and bundles
ChartHop apps
ChartHop bundles
Performance management
Performance reviews
Org management
About org management
Working with jobs
Working with people
Working with job history
Announcing org changes
Planning
Scenarios
Headcount planning
Compensation reviews
Legacy compensation reviews
Compensation bands
Viewing your people data
ChartHop reports
Partners
Sequoia getting started
Accessing ChartHop as a Sequoia customer
ChartHop first run guide for Sequoia customers
ChartHop features available to Sequoia customers
Troubleshooting common sync errors
Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Resources
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
Docs powered by archbee 

Filtering data in a report

Packages: Basic | Standard | Premium

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.

By default, the filters that you select are applied globally to all charts unless you define chart-specific filters to override the ones defined at the report level.

Report filter
Report filter

Filter global report data

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. 

Save a report filter

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.

Filter chart data

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

You must be a report owner or have edit access to be able to edit and apply chart filters.

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.



Updated 14 Dec 2022
Did this page help you?
Yes
No
UP NEXT
Sharing a report
Docs powered by archbee 
TABLE OF CONTENTS
Filter global report data
Save a report filter
Filter chart data