Gizmo Cookbook
Orgvue Knowledgebase
Support
Preface
Introduction to Gizmo Expressions
Gizmo editor
Results Pane
Saving Expressions to a Pack
Calculation Mode
Saving Expressions to a Dataset
Property Expression Mode
Property Evaluation Mode
Expression and Evaluation Mode Relationship
Default Boolean Values
Nodes and Collections
Dot Notation versus Bracket Notation
Basic grammar
Accessing Properties
Dataset Properties
Generated Properties
Relationship Properties
Methods
Generated properties
Introduction
Referencing Generated Properties
List of Generated Properties
All Datasets
Hierarchical Datasets Only
Unique IDs
orgvue Generated IDs
Operators
Arithmetic Operators
Logical Operators
Comparison Operators
Conditional Operators
Search Operators
Numbers
Basic arithmetic (+, -, *, /)
Example Mathematical Expressions
Add two properties
Calculate Percentage
Calculate and Format result
Calculate and Round result
Calculate with Relationship Properties
Aggregating Numbers
Sum
Sum and Format
Average of direct reports
Distinct Cnt
Distinct Count
Cnt or Count ?
Max
Max of Children
Formatting numbers
Format
Join
Precision
Round
Floor
Ceil
Trunc
Advanced Mathematical Operations
Math Power
Square Root
Absolute Values
Natural Logarithms
Random Number Generation
PI
Viewing statistics
Statistics All Nodes
Statistics for Subset of Nodes
Statistics Node Buckets
Strings (text)
Combining strings
Format
Joining two properties
Joining property and text
Joining number property and number text
Concat
Join
Join with Conditional Logic
Splitting strings
Slicing strings
Finding values in strings
IndexOf
Match
String matching
Matching of characters
Sophisticated Pattern matching
Replacing strings
Dates
Age
Calculate age using date of birth
Calculate weeks in role
Calculate average tenure
Anniversary
Calculating difference between two dates
Difference between two date properties
Aggregated difference between dates
Calculating a future date
Calculate a service anniversary
How long until a future date
Inputting & Formatting dates
Input Dates
Now
Today
Day Of Week
Day Of Month
Day Of Year
Month
Quarter
Year
Format Dates
Date Format Options
Conditional logic
If statement
Operators in If Statements
Multiple Else If statements
Is Equal isEq
Is a node equal to a value
Is a node equal to another in hierarchy
Does a node share multiple values with another
Is
Type Operators
Number
Date
Found
Comparison Operators
Greater Than, Less Than and Equal
True or False
Node Functions
And
Not
In
Is Prop
isEmpty
Logical Operators
Every
Some
At Least, At Most
Exactly
Match
Case
Fallback option using case
Using Case with Is
Using Case over a collection of nodes
Using case to test multiple values
Guard
Using guard with links
Nullish Coalescing
Grouping data
Lambda expressions
Using Lambda with map
Filtering
Filter on the value of a property
Filter on a node function
Filter children of a node using a property
Filter using a lambda
Sorting
Sorting Values
Sorting Strings
Sorting Numerical Data
Grouping collections
Lookups and links
Lookups
Lookups in Auto Mode
Lookups in Dataset Mode
Lookups in calculations
Links
Viewing Links between datasets
Calculating sum of links
Calculating the cost using links
Linked values with aggregators
Links with conditional logic
Hierarchical aggregation
Rollup
Rollup sum
Rollup excluding self
Rollup with filters
Rollup other aggregators
Rollup with a lambda
Advanced rollup Calculations
Distinct count of property values
Distinct code of nodes
Traverse excluding self
Traverse on filtered data
Viewing properties
List all properties
Number of properties in dataset
Number of data properties only
Number of evaluated properties
Count of number properties
Viewing details of a dataset
Viewing property buckets of dataset
Published with GitBook
Hierarchical aggregation
Rollup and traverse
Contents
Rollup
Traverse
results matching "
"
No results matching "
"
results matching "
"
No results matching "
"