Introduction

The Orgvue scripting language, Gizmo, allows you to perform querying, calculations, aggregations and transformations on your data and save those expressions to a property for use in your analysis and visualization.

Typical use cases of Gizmo Expressions

1. Quickly get answers to complex questions, for example:
   • what is the total revenue per employee of the sales department?
   • what is the average age of all female program managers?
2. Create custom metrics using existing data, for example:
   • ratio of front to back office staff?
   • benefits as a percent of salary?
3. Manipulate text and numbers, for example:
   • increase everyone’s salary by 10%?
   • convert employees’ performance scores in numbers to A, B, C and D.

Note: Compared to Filter Control, Search Box and various visualization options, Gizmo can be quicker to get an answer to complex and specific questions, and it further allows manipulation of the results.

Data in Orgvue is stored as nodes which have properties

Expressions allow you to manipulate these node.property values

Gizmo is the language that is used to write these expressions

Expressions can be understood as the Orgvue equivalent of Excel formulas

Gizmo expressions can be written or stored in three different places:

1. in the Gizmo editor: when you want to perform a calculation on-the-fly and then save that expression for use later.
2. within the expression panel via settings: when editing a property within property manager in settings
3. In a Pack Property: when you want to save an expression for use again in a specific pack to support analysis