- OrgChart Overview
- Quick Start Guides
- Top Toolbar
- Viewer
- Directory
- Planning
- Point in Time
- Workbench
- View Manager
- Chart Settings
- Account Settings
- Connectors
- Append Data Connectors
- Merge Data Connectors
- Photo Integrations
- Active Directory
- ADP
- ADP Recruitment
- Append Table
- Azure AD
- BambooHR
- Breathe HR
- ClearCompany
- Cornerstone
- CSV
- Dayforce
- Excel
- Google Directory
- Greenhouse
- iCIMS
- Jobvite
- Lever
- Namely
- Oracle
- OrangeHRM
- Paychex
- Paycom
- Paycor
- Paylocity
- PaySpace
- PeopleHR
- Sage
- Salesforce
- SFTP Pull
- Signify
- Subscribe HR
- SuccessFactors
- Thrive TRM
- TriNet
- UKG Pro (API)
- UKG Pro (RaaS)
- UKG Ready
- Unicorn HRO
- Workday
- Append Data Connectors
- Topics
- Admin User Impersonations
- Automatically Export to SharePoint
- Auto-Assignment Example
- Auxiliary Reporting
- Co-Head Example
- Creating a Master Chart
- Creating a Master Page
- Creating Shortcuts
- Dynamic Localization
- Flat File Prep
- Formulas
- Functional Charts
- Import Filters
- Index Page
- Inverted Charts
- Level Charts
- Multi-Chart Documents
- Multi-Tenant Access
- Pie Chart Example
- Point-in-Time Charts
- Restricted Link Setup
- Security Profiles
- SSO Configuration
- Release Notes
- Troubleshooting
- Legal
- Contact Us
AVERAGE
Audience
Audience: Administrators Edition: Team, Enterprise, & Premium
Overview
The AVERAGE formula allows users to average a field (for example, average age).
Creating AVERAGE Formula in Workbench
With a chart open, select the Document Ribbon.
Select the Field Manager icon.
Select the Add Formula button.
Select AVERAGE from the dropdown list.
Select which field you want to average using the field dropdown list.
Select the range using the range dropdown list (see range definitions below).
Select OK.
Rename the formula (e.g. Average Salary).
Select OK to complete the rename.
Select OK to save and exit.
The field will now appear in the Profile panel, and be available to be included in Box Styles.
Range Options
When creating an AVERAGE calculation, you can specify the range to include in the calculation. The following range options are available:
Self + Subordinates: checks current box and all subordinates (direct and indirect)
Subordinates: checks all subordinates (directs and indirect)
Self + Direct Reports: check current box and only direct reports
Direct Reports: checks only direct reports
Creating AVERAGE Formula in Viewer
Select