The Formula Editor is where you define formulas for your widgets.

If you are familiar with the Formula Editor, see the Quick Reference Guide. For a detailed guide with examples, continue reading below.

To open the formula editor:

  • Do one of the following:
    • For a new widget, click Select Data, and then  formula button  to open the formula editor.
    • For an existing widget, click on the edit formula button edit to open the formula editor.

The formula editor has two tabs, the Data Browser to select fields and the Functions tab to select formula operations. You can create a formula combining one or more function, field and filters. The diagram below highlights the main components of the formula panel.FormulaEditorFlow1

  1. Functions are operations which perform different calculations, for example a sum. Use the ‘Jump To’ menu or the search box to quickly find the formula you need.
  2. Fields in the Data Browser are variables contained in the data set (ElastiCube). Clicking on a field in the data browser will include it as part of the formula.
  3. Filters can be applied to restrict formulas based on criteria.
  4. Starring is a way to save a formula for later use.
  5. The formula editor window can be expanded by clicking the expand button at the top right.