What are derived attributes & how to use them?
Annu
Derived attributes are special type of attributes that are dependent on other attributes & constants. e.g. age is a derived attribute and can be calculated using today's date & the date of birth. UpRaise app supports these special type of attributes. Unlike other attributes, these derived attributes cannot be assigned any value directly. A formula is associated with them based on which they derive the attribute value for every user, in real time. Continuing with the example of Age - if an attribute Date of birth is already available it is easy to derive Age based on it & the Current date. As shown in images below, a formula (with specific syntax) is associated with such attributes. UpRaise app currently supports following two derived attributes. Stay with us - Calculates and displayes the duration of the employee's association within company (using current date & given joining date of the employee) Age - Derives a value that equals to the employee's age (using current date & given date of birth of the employee) Stay with us attribute is derived from joining date of employment details section. Stay with us attribute provides a value that is equal to the real-time tenure of the employee. As shown in the image below, the type of stay with us attribute is stated as Derived which is selected by default. This attribute type and its formula acnnot be edited as this a defual attribute. Let us see what formula is used to calculate the stay with our value. DAYSDIFF([CurrentDate], att(9)) This syntax is specific to UpRaise. Click on Edit option of attribute from where you want to derive some value (in this case from Joining date attribute). On edit pop-up, notice a number at the right top corner, that is the identifier used in the formula. As per the below formula: DAYSDIFF([CurrentDate], att(9)) 1years,7 months, & 10 days = ([11-01-22] - (21-08-2023)) The same formula is applicable to the Age attribute, which is again a derived attribute from Date of birth. DAYSDIFF([CurrentDate], att(305)) This syntax is specific to UpRaise . As per formula below - DAYSDIFF([CurrentDate], att(2235)) 34years,04 months, and 17 days = ([21 Aug 2023] - (04 Apr 1989))How does it work?
Stay with us
Formula
How to find the attribute key?
Final output on user profile
Age Formula
Final output on a user profile
On this page
In this section
- Concepts - Users, Roles, Designations, Managers & Teams
- How do I create, edit & delete designations?
- How to create,edit or delete users in UpRaise?
- How do I manage user roles in UpRaise for Employee Success company directory?
- How do I manage teams & team members?
- How to add new attributes in profile sections?
- How to add, delete or edit profile sections?
- How to edit or delete user profile attributes from sections?
- How to manage columns on users page in company directory?
- How to sync UpRaise team to Jira issue custom fields?
- What all filters are available to search users & teams in company directory?
- What are derived attributes & how to use them?
- What is the difference between super admin & admin?
- How do I export user profile attributes from company directory?
- What is global search and how it works?
- UpRaise roles and permissions
- How to mark a team as inactive?
- How to sync & import from Jira users to UpRaise company directory?
- How do I integrate with AD, LDAP & other HRIS tools for centralized user management?
- How can Jira admin/s make someone UpRaise admin/super admin?
- What are 'Units' and how to use them in UpRaise?
- Bulk edit user profile attributes