Carrot can do a lot! So examples are helpful.

This is a growing guidebook of examples of CQL in action for real usecases that we've encountered.

Quick Reference: Common Filters

Examples

ChartHop Premium: You can work with ChartHop implementation services to customize what is synced.

data-mapping

note

Transform Type refers to the logic employed when copying data from the source field to the target.

note-tranform-type

Package_Premium

Creating a dashboard of top submitters

ChartHop documentation

ChartHop Docs

ChartHop Help Center

ChartHop Directory Mobile App

ChartHop Video Library

ChartHop terminology

Markdown formatting

Filtering data

Hiding sensitive data

Navigating ChartHop

Home page

Export your Org Chart to slides

Embed your Org Chart on a webpage

Org Chart

Editing data in the Data Sheet

Creating Data Sheet views

Syncing Data Sheet views to a spreadsheet

Exporting data from the Data Sheet

People Data Sheet

Data Sheet

Calendar

Viewing employee profiles

Employee Profiles

Getting around in ChartHop

Signing in to ChartHop for the first time

View your profile information

Control what people see on your profile

Set your work location

Update your org profile image

Customize your employee profile

Complete tasks and forms

Give a Shoutout

Change your password

Edit your user settings

Sync your calendar with ChartHop

ChartHop for Employees

ChartHop implementation overview

Syncing your payroll system

Syncing your hiring plan 

Import payroll data for ChartHop Basic

Syncing data via an SFTP server

Creating your ChartHop org

Payroll systems

Applicant tracking systems

Equity syncs

FP&A

Identity & SSO

Slack

Apps & Integrations

Birthday announcements

Work Anniversary announcements

Nine box ratings

Shoutouts

Bundles

Implementing ChartHop

Fields

Sync history

Importing spreadsheet data

Editing employee profiles

Managing data

Group details

Group names and aliases

Departments

Teams

Locations

Bands

Job codes

Managing groups

About org management

Working with people

Working with jobs

Working with job history

Announcing org changes

Effective dating

Managing people and jobs

Working with custom dashboards

Configuring charts

Chart types

Advanced chart customization

Filtering data in a dashboard

Sharing a dashboard

Duplicate, export, or delete a dashboard

Dashboards

Scenarios

Headcount planning

Compensation bands

Planning

Creating a new compensation review

Setting up a compensation review

Managing a compensation review

Concluding a compensation review

Compensation reviews owner FAQs

Participating in a compensation review

Compensation reviews

Create a review

Adding forms to a review

Managing forms in a review

Monitoring participation in a review

Collaborating in a review

Closing a review

Export form responses in a review (cloned)

Viewing review data in ChartHop

Performance reviews

Create a survey

Adding forms to a survey

Managing forms in a survey

Monitoring participation in a survey

Collaborating in a survey

Closing a survey

Export form responses in a survey

View survey responses

Engagement surveys

Forms

New hire management

Letter templates

Managing tasks

People Ops Tools

User access controls

User management

Access Settings

Untitled

Configuring general settings

Configuring the Home page

Configuring Org Chart Defaults

Configuring Data Sheet Defaults

Managing data sheet and calendar syncs

Notification preferences

Configuring financial settings

Enabling approvals

Configuring profiles

Admin settings

ChartHop for Administrators

Getting started with Carrot

Key Concepts

Basic Org Information

Compensation

Job Changes

Permissions

Personal

Recruiting

Structure

Time off

Data Types

+ (add)

- (subtract)

* (multiply)

/ (divide)

% (modulus)

= (equals)

!= (not-equals)

! (not)

> (greater-than)

>= (greater-than-equals)

< (less-than)

<= (less-than-equals)

[ ](array)

: (match)

&& (and)

|| (or)

? (ternary)

?: (elvis)

. (dot)

Operators

abs()

asOf()

boolean()

compHistory()

compBetween()

costBetween()

date()

day()

daysOffBetween()

diffYears()

diffMonths()

distance()

monthEnd()

findFormTasks()

findFormTasksByAssessment()

findResponses()

formatMoney()

formatRound()

formatNumber()

formatPercent()

formatDate()

grantedShares()

length()

limit()

max()

mean()

money()

Functions

Carrot reference