ind
IND works in the same way as GRP, but the value is an index rather than a sum. The function is similar to the Index function. The main difference is that the IND function is not organization-based, but rather a processing method, which makes it possible to use it in addition to organization-based functions like AGG and TOP.
Syntax
IND('[nodeId]') AS 'name'
When used in combination with an AGG function the syntax for the function can be :
AGG('IND('[node1]')',organization)
In this case the function gives the same result as the following INDEX function:
INDEX('[node1]',organization)
The advantage of using IND is that you can create summing levels in drills.
Use
Use IND to calculate an index in combination with TOP functions.
Use IND to build and name sum levels in drills. The INDEX function cannot do this.
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'
"Good management" will not appear as a summing level in the drill if an INDEX function is used. By using an IND function this sum level will be displayed.
How to create
In the Function calculator, click the GRP button and choose IND. A new calculator window opens. Now create the function in the normal way by defining time adjustments, selecting nodes, and clicking or entering numbers and operators. Click OK when finished.
