The Data Browser enables you to define formulas (freeform expressions) that define the values and filters of a widget.

A rich variety of functions are provided for you to use in the formula that you define.

To define a formula:

  1. Open the formula editor in the Data Browser:
    • 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.

formulaClick

The Data Browser then changes to display the FORMULA EDITOR, which has two tabs: Data Browser and Functions.

  • The Data Browser tab provides fields to choose from.
  • The Functions tab lists the functions that you can include in your formula by selecting them. You can read a description of each function in a tooltip by hovering over it.
  1. Define the formula as follows:
    • From the Data Browser tab, select one or more fields.
    • From the Functions tab, select the required functions.
      browserdata
  1. Type in the required parts of the formula. To see examples, see Formulas Based on Criteria and Conditions, and Functions to Build Formulas.
  2. Click OK.

To edit a formula:

You can easily edit formulas using the right-click options. They include:

  • Rename: Rename the formula, for example, give a name that represents a real-life task or expected result from the formula, or include in the name filters that you have added to the formula.
  • Filter: Add filters to the formula.
  • Type: Change the default aggregation method, for example, from Sum to Average.

The following image shows the right-click options.

edit formula

The following image shows right-click options for a filtered formula. Read more below.

edit formula2