OrgChart Now Help Guide

Tenure Example

Audience:

Audience: Administrator Users Edition: Enterprise & Premium

Overview

OrgChart Now allows Administrators to create a formula for calculating an employee's years of service. The following article provides step-by-step instructions for creating a Tenure formula in OrgChart Viewer.

Creating a Tenure Formula
  1. Sign in to OrgChart Viewer.

  2. Click on More > Chart Settings, and then select the Field and Formulas option from the settings dropdown menu.

  3. Click on the +f(x) button (in the top right corner). The Static Formula Editor panel is displayed.

  4. Enter a name for the formula (i.e. Tenure) in the Formula Name text box.

  5. Click on the "No values. Click here to add." hyperlink in the Operations column.

  6. Select the Concatenate option from the dropdown menu.

  7. Click on the Type dropdown menu, and then select the Date option.

    StaticFormula_Tenure_SelectDate.png
  8. Click on the Plus_New_Blue_Wide.png icon (in the Operations panel), and then select the Concatenate option.

  9. Click on the Type dropdown menu, and then select the Field Lookup option.

  10. Click on the Value dropdown menu, and then select the field associated with the date of hire in your source data (i.e. Hire Date).

  11. Click on the Plus_New_Blue_Wide.png icon (in the Operations panel), and then select the Subtract option.

  12. Click on the Treat Value as dropdown menu, and then select the Date option.

  13. Click on Save. The Tenure formula is added to the list of Fields and Formulas.

  14. Mouse over the Tenure, and then click on the Pencil_Edit_Icon.png icon. The Field editor is displayed.

  15. Click on the Field Type dropdown menu, and the select the Number option.

    StaticFormula_Tenure_EditField.png
  16. Optionally, click on the Decimal Places dropdown menu to select how many decimals places you would like shown in the field value.

  17. Click on Save.

  18. Click on Refresh, and then select the Yes option to preserve your changes.