Global: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
Line 12: Line 12:


===Input===
===Input===
By making use of the 'global selection' in generating a [[TQL|query]] for an Excel, the global is used to generate input by an [[Excel|Excel calculation]]Excel calculation.
By making use of the <code>UPDATE_GLOBAL</code> function in generating a [[TQL|query]] for an Excel, the global is used to generate input by an [[Excel|Excel calculation]].
The second way of using a global as input is by connecting the global to an [[Events|Event Bundel]]. The value of the global can be used in the [[Events|event]] to influence an indicator.
The second way of using a global as input is by connecting the global to an [[Events|Event Bundel]]. The value of the global can be used in the [[Events|event]] to influence an indicator.



Revision as of 11:47, 1 August 2016

Template:Learned

Global

A global is a number that is integrated in the project but is not necessarily assigned to a specific construction. The global can be used for example, in Excel calculations and influence the calculation of an Excel indicator.

Type of globals

There is one type of global that can be applied in different ways. A global is always made up of a name of the global and a number. Based on the purpose of the global the number represent an amount or a value which is specified by the name of the global. The global name is also the global ID which is used in queries.

Output

By making use of the global in an Excel you can generate output. ook qtl? It is also possible to connect the global to the budget of a specific stakeholder to directly influence the budget during a session.

Input

By making use of the UPDATE_GLOBAL function in generating a query for an Excel, the global is used to generate input by an Excel calculation. The second way of using a global as input is by connecting the global to an Event Bundel. The value of the global can be used in the event to influence an indicator.

Add and remove Globals

Template:Editor ribbon

The Left Panel allows you to add, duplicate, and remove globals.
How to add a global:
  1. In the ribbon header, select "Indicators".
  2. In the ribbon bar, select "Globals".
  3. In the left panel, select "Add".
How to duplicate a global:
  1. In the ribbon header, select "Indicators".
  2. In the ribbon bar, select "Globals".
  3. In the left panel, select the global you wish to duplicate.
  4. In the left panel, select "Duplicate".
How to remove a global:
  1. In the ribbon header, select "Indicators".
  2. In the ribbon bar, select "Globals".
  3. In the left panel, select the global you wish to remove.
  4. In the left panel, select "Remove".


Global Uses

When you have created a global the can be used communicate with a Microsoft Excel spreadsheet, when using such a spreadsheet for a (custom) Excel Indicator. Also, globals are currently used to attach to event bundels and hereby influence the progress of indicators. Read more about how to connect the global to an Event Bundel on the events page.