Square Root

Square roots are needed in a variety of mathematical equations dealing with variance and statistical modelling. They are also required for some KPIs, e.g. bradford factor - which converts absence to a numerical score which weights absence instances as more important as absence duration.

Excel

=~SQRT!~(‹number›)

=SQRT(A1)

=SQRT(4) // Returns 2

Tableau

~SQRT!~(‹measure›)

SQRT([Engagement])

SQRT(4) // Returns 2

Alteryx

~SQRT!~(‹measure›)

SQRT([Engagement])

SQRT(4) // Returns 2

OrgVue

~Math.sqrt!~(‹measure›) ~Math.sqrt!~(‹number›)

Math.sqrt(node.engagement)

Math.sqrt(4) // Returns 2

tSQL

~SQRT!~(‹number›)

SELECT SQRT(Bradford)
FROM AbsenceData

Python

~math.sqrt!~(‹number›)

import math

math.sqrt(engagement)

math.sqrt(4) # Returns 2

NB.:

• This requires the math library to be imported.

• The above example assumes a variable has been declared for engagement. For more information, go to General > Variables.