Just like reusing formulas, quick functions is another feature to make working with formulas easier. The Widget Designer provides a variety of predefined commonly used functions that you can easily apply in the Data Browser when selecting a Value to be included in a widget.
Quick Functions instantly add a time dimension to any existing value and formula. These functions include calculations for past values, change over time, contribution and running totals. Quick Functions include all the Time Functions previously discussed but they can only be accessed by clicking on a formula that is already present in a widget.
A simple example of a Quick Function is a finance manager who is reviewing total costs per month but needs to track the accumulated annual costs. They can simply use a quick function to calculate the year to date total for costs.
Note: Running Sum and Running Average functions are available for ElastiCube models only.
To use a quick function:
- Hover and click on the menu icon of a numeric field in the data panel of the widget designer, and select Quick Functions from the menu:
A list of commonly used functions is displayed.
- Select a function. The widget will be updated immediately.
Adding Aggregate Functions
You can also add aggregate functions to your formula without opening the formula editor.
Click on the Value icon to open a list of aggregate functions, and select the function to apply to your formula.
Starring Formulas with Quick functions
A more complex example uses starring with multiple quick functions. Let’s say a finance manager also wants to compare year to date costs to the same period for the previous year. They can first apply the year to date function to total cost and then save it to the formula repository. They can then add the saved year to date formula but apply another quick formula for past values which will perform the same calculation but on data from the previous year.
Note: Starred (favorite) formulas will be shared with other users.