Excerpt

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.

How does it work?

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'

Age - if an attribute

'date

Date of birth

'

is already available it is easy to derive

'age'

Age based on it & the

current

Current date. As

you would see in the screenshots

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 -

Gives you

Calculates and displayes the duration of the employee's association

with your

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

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.

If you look at

As shown in the image below, the type of stay with us attribute is stated as

'derived'

Derived which is selected by default.

You cannot make any changes in this

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.

Image Removed

Image Added

Formula

DAYSDIFF([CurrentDate], att(9))

This syntax is specific to UpRaise.

How to find the attribute key?

Click on

edit

Edit option of attribute from where you want to derive some value (in this case from Joining date attribute). On edit pop-up,

you will see

notice a number at the right top corner, that is the identifier used in the formula.

Image Removed

Image Added

Final output on user profile

As per the below formula:

DAYSDIFF([CurrentDate], att(9))

1years,7 months, & 10 days = ([

26 Apr 2018

11-01-22] - (

16 Sep 2016

21-08-2023))

Image Removed

Image Added

Age

The same formula is applicable to the

age

Age attribute, which is again a derived attribute from

date

Date of birth

in personal details section in the system

.

Image Removed

Image Added