Zoomdata Version

Creating and Modifying Custom Metrics

Custom metrics are created and modified using the Calculations Editor.


To create or modify a custom metric:

  1. Access the Calculations Editor in any of the ways described in Calculations Editor.

  2. Enter a name for the custom metric in the space labeled Untitled Calculation.

    If you are using non-Latin characters in your functions, the name for your custom metric should start with a letter or an underscore (_) symbol followed by one or more letters, numbers, underscore, or period characters. Symbols other than the underscore (_) or period (.) are not allowed.
  3. Enter the expression for the custom metric in the editing space. Expressions should follow standard mathematical and logical syntax and are resolved using the standard order of operations. You can manually key in expressions or you can select the elements of your expressions from the menus at the left. The expression should not be assigned to a variable because the resolved value of the expression is assigned to the custom metric, which serves as the 'variable' to which the value is assigned. That is, enter a / b rather than x = a / b.

    Row-level expressions and aggregate functions can be used in custom metrics. In addition, custom metrics can be filtered (using date and time filter aggregate functions and SQL-like expressions).

  4. To test your custom metric, click Run Calculation.

    The editor attempts to run your calculation. Any errors are reported. Any results are shown in the Preview area of the Calculations Editor.

  5. When you are finished with your custom metric definition, click Save.

Was this topic helpful?