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 for 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 throughout Jirav - its used to point Dashboard Tiles to the data you would like to display, for reports to set the values you would like to show, within Drivers to determine what is calculated and how it is calculated.
Generally the UA Picker looks like the below. Note, the Range & Reduction fields will not be appear in the UA Picker within Dashboards & Reports.
Here is a listing of what each of the boxes mean:
- Category - 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 category and the additional filters are Department & Account. Whereas if Staffing Salaries $ is selected as the category, then the additional filters would be will be Department & Role.
- 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 - 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.