OrgVue Gizmo Cookbook

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. Link to Orgvue Gizmo Cookbook. 

Expressions can be understood as the Orgvue equivalent of Excel formulas

This cookbook is a constantly growing collection of Gizmo expressions with examples of their use in an orgvue dataset

It covers the basic grammar of the Gizmo language, common functions and optimization tips and advice

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.

The example Gizmo expressions in this user guide have been based on our downloadable example people dataset

If you have any feedback regarding this guide, please email userguide@orgvue.com