Advanced Analytics - How To Save Global formulas In Analytics Portal

Currently, users have the ability to create formulas using the formula editor Custom Filter | Create . However, it is important to note that these custom formulas cannot be saved directly to the data cube. To save the formula and make it readily available for other widgets as Global formula, users need to be enrolled at the Enterprise level and have access to the Advanced Analytics tier.

 

Step 1: Create the formula in the value field of advance configuration for widget.

Step 2: Once the formula is finalized, edit the formula name if required. Please note the name would be used while saving the formula.

Step 3: Once the formula and name is finalized Go into formula editor mode, click on the “star” icon to save the formula.

Step 4: Once clicked system will prompt to save the Formula. Click on Green Tick and then hit the “OK” button in order to save the formula.

Step 5: The created formula now should be available under the “Formula” head of Data Browser

Note: In case Formula needs to be deleted hover the cursor on the required formula click on “more” then “Remove”