Discover how Jirav builds formulas with Drivers by using the Universal Addressability Picker
In order to simplify things for Users, Jirav has a built-in engine that allows you to point at any data line within the model, think of this as an advanced Excel formula with a user interface that is called the Universal Addressability (UA) Picker.
The UA picker is used to point Dashboard Tiles to the data you would like to display, within Goals Configuration and within Drivers to determine what is calculated and how it is calculated.
The data picker allows for searching of keywords across all data points. Generally, the UA Picker looks like the below (note, the Range & Reduction fields will not appear in the UA Picker within Dashboards and Goals):
Here is a listing of what each of the boxes means:
- Data Elements - this is the first selection you will make and will determine which additional filters will appear. For example, in the screenshot above, IS OpEx $ is selected as the Data Element, and the additional filters are Department & Account. Whereas if Staffing Salaries $ is selected as the Data Element, then the additional filters would be Department & Role. The data picker allows for searching of keywords across all data points
- Range - this determines which time period(s) to reference the category for. For example, This Month, Last Month, or a Trailing 3 months. Click here to learn more about Ranges.
- Reduction - When a range is selected that encompasses more than one period, the reduction determines the value to be used. For example, if the range is trailing 3 months, then the appropriate reduction would likely be average rather than sum.
- Data Preview - this is a table that provides a preview of the values that are contained within what you have selected as part of the Category selection, this data table will dynamically change based on what you have selected.