website logo
Navigate through spaces
ChartHop documentation
⌘K
ChartHop Help Center
Getting around in ChartHop
ChartHop Video Library
Navigating ChartHop
Home page
Org Chart
Map
Data Sheet
Employee Profiles
Implementing ChartHop
ChartHop implementation overview
Creating your ChartHop org
Configuring your Org settings
Inviting users and setting permissions
Permissions and security
Creating and managing groups
Integrations and bundles
ChartHop for Administrators
Planning
Managing employee data
Creating reports and analytics
Managing people and jobs
Performance reviews
Building custom forms, tabs, and documents
ChartHop for Developers
ChartHop connect
Developer basics
Events
Syncing data to/from ChartHop
Partners
Sequoia getting started
Resources
Available ChartHop packages
ChartHop Standard Terms and Conditions
ChartHop Basic Agreement
Data Processing Addendum
Privacy policy
Security statement
Subprocessors
FAQ
Docs powered by archbee 
website logo

Data Sheet

Packages: Basic | Standard | Premium

The Data Sheet provides a list view of your organization, which is helpful when you need to customize how you see your organization's data or edit the data for multiple employees at once.

You can use the Data Sheet as a source of truth for all the job and people data within your organization. This page gives you the ability to create a customized view of your data for all of your planning needs. You can control what data displays on the page by customizing the columns you need and sorting by a particular column. You can also use filters to refine which employees and jobs are included in the list.

The fields visible on this page are dependent on your permissions.

Customizing the Data Sheet

You can refine the Data Sheet to display only the data you need. The Data Sheet includes the following built-in views that you can select from the top of the page:

  • The Data Explorer view includes all people in your organization and the following fields as columns: Name, Job Title, Manager and Department.
  • The People view includes all people in your organization and the same fields as columns as the Data Explorer with additional columns that display team and location.
  • The Open Roles view displays all open roles and includes a complete set of recruiting and hiring fields as columns.

Customize the columns to display

You can customize which fields are used as columns. 

Select columns to include fields on the Data Sheet
Select columns to include fields on the Data Sheet
  1. Select Data Sheet from the left sidebar.
  2. On the Data Sheet page, choose Select Columns.
  3. In the Select Columns dialog, select or clear the corresponding check box next to each field you want to display in the list.
  4. Reorder the columns by dragging the fields in the Column order list.
  5. (Optional) Select the X to delete a column you don't want to use.
  6. Select Apply to save your changes.

Filtering the Data Sheet

As with most pages in ChartHop, you can filter the data displayed on the Data Sheet. With filtering, you can choose to see only those people and/or jobs in your organization that you are interested in. For example, you can filter by department or particular changes like departing employees and so on. Learn more. 

ChartHop filtering also allows you to create complex filters based on your organization structure as well as most field data. For example, you can filter on all managers that have at least two direct reports.

Use Field rules to refine your data to only those employees or jobs that meet certain criteria, like filtering the list for all employees who have birthdays in June.

Advanced users can use ChartHop's Carrot Query Language (CQL) to build complex queries. Learn more.

Filter the Data Sheet page
Filter the Data Sheet page

Analytics on the Data Sheet

On the Data Sheet, you can get a visual breakdown of the information under most column headers or perform a quick calculation on any column that contains numbers.

Get a visual breakdown of a column

To see a visual breakdown for any column that doesn't contain numbers, hover over the column heading. For example, you can view jobs by department.

Hover over a column heading to see a breakdown of the column data
Hover over a column heading to see a breakdown of the column data

Perform a calculation on a column

To perform a calculation on any numeric column, select the down arrow on the left side of the header row and choose Average, Maximum, Minimum, or Sum. The result is displayed on the right.

For example, you can view average base salary instead of the default, total base salary.

Select the down arrow on the left to perform a quick calculation
Select the down arrow on the left to perform a quick calculation
Updated 01 Feb 2023
Did this page help you?
Yes
No
UP NEXT
Editing data in the Data Sheet
Docs powered by archbee