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
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
- 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?
- Create custom metrics using existing data, for example:
- ratio of front to back office staff?
- benefits as a percent of salary?
- 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
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
If you have any feedback regarding this guide please email userguide@orgvue.com