An aggregator in Carrot appears as a word followed by curly brackets, which contain an expression. All aggregators are case-insensitive.

Aggregation is only available in reports. Smart calculations and buckets only evaluate data of an individual person or job.

An aggregator performs a calculation on an expression and returns a 

Aggregators

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

count{}

ChartHop - Carrot reference

⛔️  Carrot reference

Carrot reference

Built-in Carrot filters

Getting started with Carrot

Employee

Time

Organization

Basic Org Information

Bands

Base

Variable

Cash

Equity

Compensation

Current Change

Base Comp Changes

Data Fields

Depart Type

Promotion

Change Reason

Depart Regret

Changed in Scenario

Update Type

Job Changes

Can this person approve this change?

Can this user edit this job?

Data Access

 Data Access Sensitive

Sensitivity

Permissions

Address

External apps

Member profile

Personal

Active (Days)

Annual Budget Cost

Backfill For

Backfill Job

Candidates (Active)

Hiring Manager

Interviews (Active)

Lever Req ID

Offer Accept Date

Offers (Active)

Offers (Total)

Open (days)

Priority (Recruiting)

Recruit Active Date

Recruiter

Recruiting

Time to Fill (days)

Dates

Groups

Headcount

Management

Structure

Days Off (All Types)

Days Off (Bereavement)

Days Off (In Lieu)

Days Off (Jury Duty)

Days Off (LT Disability)

Days Off (Medical)

Days Off (Military)

Days Off (Offsite)

Days Off (Parental)

Days Off (PTO)

Days Off (Religious)

Days Off (Sick)

Days Off (ST Disability)

Days Off (Unknown)

Days Off (Unpaid)

Days Off (Vacation)

Days Off (Voting)

Days Off Used (current year)

Days Off Taken (current year)

Days Off Upcoming (current year)

Next Day Off

Previous Day Off

Next Time Off

Previous Time Off

Time off

Boolean

Comp

Comp Band

Currency

Date

DateTime

DaysOff

Enum

EnumList

File

Group

Image

List

Money

Name

Number

Null

Percent

Person

PersonList

Shares

StockGrant

String

TimeOff

User

Data types

Carrot fields

abs()

asOf()

boolean()

compHistory()

compBetween()

costBetween()

date()

day()

daysOffBetween()

diffYears()

diffMonths()

distance()

monthEnd()

formatMoney()

formatRound()

formatNumber()

formatPercent()

formatDate()

grantedShares()

length()

max()

mean()

money()

month()

min()

nextAnniversary()

number()

pluralize()

percent()

random()

round()

roundUp()

roundDown()

string()

subString()

stockPrice()

monthStart()

split()

vestValue()

vestShares()

year()

Functions

+ (add)

- (subtract)

* (multiply)

/ (divide)

% (modulus)

= (equals)

!= (not-equals)

! (not)

> (greater-than)

>= (greater-than-equals)

< (less-than)

<= (less-than-equals)

[ ](array)

Operators

: (match)

&& (and)

|| (or)

? (ternary)

?: (elvis)

. (dot)

Keywords

max{}

mean{}

min{}

sum{}

Elements of Carrot expressions

Aggregator	Description
count{}	Counts the number of times a given expression evaluates to a truthy value. All non-truthy values, such as null, an empty string, 0, or false are discarded.
max{}	Returns the largest value of a given expression. All non-numeric values are discarded.
mean{}	Returns the average of all values of a given expression. All non-numeric values are discarded.
min{}	Returns the smallest value of a given expression. All non-numeric values are discarded.
sum{}	Returns the sum of all values of a given expression. All non-numeric values are discarded.

Aggregators

Aggregator list