Adding expressions to KPI widgets

Note: Some report expressions may already be listed in the KPI Measure list. Check the list before creating a new expression. Expressions created for a KPI are saved for only the KPI and cannot be shared.
  1. From the KPI Builder, select the Measure tab.
  2. Click + Add Expression. The Expression Builder opens.
  3. Specify the Name for the expression.
  4. Specify the expression.
    If you are proficient in BQL or have a pre-existing query:
    1. Select Advanced mode.
    2. Specify or paste the query into the text field.
    3. Click Done.
    Alternatively, using Basic mode:
    1. Specify the name of one of the existing measures the Code field. Possible measures are displayed based on the characters you specify..
    2. Select the operator from the list or specify a shortcut such as asterisk (*).
    3. Select another measure and iterate until the expression is complete.


    4. Optionally, click the selected measure to change its Aggregation or Analyze By Date settings.


    5. Click Done.
      Note: The message "Expression is incomplete" displays at the bottom and Done is unavailable until there is a complete expression in the Code field.
  5. Click Done. The title and value of the expression display in the KPI widget.
    To edit an existing expression, select it in the KPI Measures list and rest your cursor to see the Edit button.