index

INDEX is a function that is often used to calculate survey results, and works as an AGG divided by a NOR (Number of records), i.e. the sum of all results divided by the number of results.

Syntax

INDEX(<divisor>,'[node1]',organization,organization)

The divisor is an optional setting and does not need to be set in a normal INDEX function.

How it works

If you use the INDEX function on several organizations, the values for all the organizations will be summed and then divided by the number of records for all organizations.

Example:

Node 1 - Organization 1, Value = 5, NOR = 2 (INDEX = 2.5)

Node 1 - Organization 2, Value = 10, NOR = 2 (INDEX = 5)

With this function:

INDEX('[node1]',organization 1,organization 2)

the result will be:

(2.5 + 5) / 2 = 3.75

How to create

In the calculator, click the INDEX button. A new calculator window is opened. Now create the function by creating the desired Time function, selecting nodes 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: INDEX('[node1]/[node2]', Organization1)

- Add children only - Include values from suborganizations of the selected organization only

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

- Add current and children - Include values from the selected organization and all suborganizations

Example: INDEX('[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: INDEX('[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:

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

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

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

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

Renaming in functions

You can use 'AS' in functions that contains "organization", e.g. AGG, AGGAVG, IND, as well as TOP functions to give functions different names when displayed in drills.

Examples:

You want to sum up two nodes that say something about "Good management". This function will rename the IND function in drills to "Good management", and you will see it when you click on an organization name in the drill:

AGG('IND('[Just manager]+[Visible manager]') AS 'Good management'',organization)

This function will rename the AGG function in drills to "Good management":

AGG('IND('[Just manager]+[ Visible manager]')',100) AS 'Good management'