top

TOP is a group of functions that are used to compare different organizations' achievements. The functions are often used to set goals and levels of ambition.

 

The following functions are available:

• TQH - Top Quartile High (25%)

• TQL - Top Quartile Low (25%)

• TQAH - Top Quartile Average High (12,5%)

• TQAL - Top Quartile Average Low (12,5%)

• TDH - Top Decile High (10%)

• TDL - Top Decile Low  (10%)

• TNH - Top N high (specify the desired percentage)

• TNL - Top N low (specify the desired percentage)

• MAX - Highest value for the organizations in the comparison

• MIN - Lowest value for the organizations in the comparison

 

How it works

KPI values for all organizations are calculated and sorted from best to worst. Based on the TOP function, the Function calculator finds the value that represents the desired portion, e.g. the Top Decile ('TD'), i.e. that 10% of the organizations are better than the value shown and 90% are worse.

 

The decision whether to use 'L' (low) or 'H' (high) depends on whether a high value is good or not. E.g. absence due to illness will use TDL (low) while profit will use TDH (high).

 

If organizations have the value NA (invalid) or NaN (infinite, dividing by zero) in a period, these will automatically be set to zero in TOP calculations and will not be taken into account.

 

Use

TOP functions have many areas of use. They can be used to set dynamic goals based on results in other organizations.

 

Example

Absence due to illness:

 

TDL('[120/121]',org1,org2,org3... org 10)

 

This will give the absence percentage at which 10% of the specified organizations are better and 90% are worse.

 

TOP functions can be combined with other KPI functions, e.g. by combining a TOP function with a PC function to show the highest sales within several periods.

 

How to create

In the Function calculator, click the TOP button and choose the desired TOP function by double clicking. A new calculator window opens. Now create the function by selecting the desired Time function, double clicking the desired node and clicking or entering numbers and operators. Click OK when finished.

 

Next you must specify the organizations from which figures are to be included.

 

• Click the desired organization on the right and the desired symbol in the middle. You can choose between the following:

  • Add only current - Include values from the selected organization only

Example: TQH('[node1]/[node2]', Organization1)

• • Add children only - Include values from sub-organizations of the selected organization only

Example: TQH('[node1]/[node2]', +Organization1)

 

• • Add current and children - Include values from the selected organization and all sub- organizations

Example: TQH('[node1]/[node2]', *Organization1)

 

• To always use values from the KPI's organization (current organization) mark the 'Include this' checkbox and select 'Include only 'this'', 'Include children only' (+this), or 'Include 'this' and children' (*this).

Example: TQH('[node1]/[node2]',this)

 

• To use values from all organizations on one or more levels, i.e. all children of the same parent organization, mark the 'Include parent' checkbox and select 'Include only 'this'', 'Include children only' (+parent), or 'Include 'this' and children' (*parent).

  • Level - specify the number of levels to traverse

Examples:

TQH'[100]',parent) or TQH('[100]',parent1) - to access parent of current context

TQH('[100]',parent2) - to access grandparent of current context

TQH('[100]',parent5) - to access great-great-great-great-grandparent of current context

 

Now click OK and the Calculation field contains the completed function.

 

 

 

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.