Zoomdata Version

About Custom Metrics

Custom metrics, formerly called calculations, serve as additional metrics to use with your charts to help you analyze your data. When you define a data source configuration, you can create custom metrics for it. After custom metrics are defined, they are listed with the other metrics in your charts and dashboards that use the data source and can be used just as any other metric.

You can use custom metrics to aggregate data in different ways, whether from an entire data source or from a selected subset and, as needed, applying arithmetic operators to them. Because a custom metric represents aggregated data, it must be created using an aggregate function. Data can be aggregated on a column-wide scope, a table scope, or a window scope. For more information, see Supported Aggregation Functions.

Scope of data refers to the domain of data included in a custom metric - whether a whole column from the data source, or just part of the column. Zoomdata always excludes data from a custom metric if it is excluded from the chart by a filter even if that data would otherwise be included in the scope of the custom metric. You can further control what data is included by choosing metric functions that match the scope you want.

You can also use row-level functions and constant values to build your formula for a custom metric. In this way, you can create custom metrics of percentages, differences, averages, and the like. For more information about row-level functions, see Supported Row-Level Functions.

Custom metrics can be filtered. Filters are created using the SQL-like expressions WHERE and TRANSFORM and may also use date and time filter aggregate functions. For more information about the use of filters in custom metrics, see Applying Filters to Custom Metrics.

For information on creating and deleting custom metrics, see the following links:

Was this topic helpful?