Connecting to databases other than Google Analytics requires an Enterprise plan. Contact Sales for details.

​
Introduction to Metrics

Metrics provide quantifiable measurements to gauge performance, behavior, and other essential information. They facilitate in-depth analysis by offering insights not readily apparent from raw data.

​
Defining Metrics

Defining metrics involves several key parameters:

Name

The reference name for the metric, which must be unique across all metrics.

Description

A detailed overview of the metric.

Type

Type of metric (simple, ratio, cumulative, derived).

Type Parameters

Parameters specific to each metric type.

​
How to create and edit a metric

In the Catalog section, click the Manage button on the desired data source. Then, navigate to the Metrics tab to create or edit a metric. To better understand the structure, here’s an illustrative example of a metrics specification: 
metrics:
  - name: order_total
    description: Total orders processed.
    type: simple
    type_params:
      measure: order_count
    label: Total Orders

​
Supported Metric Types

Findly supports various metric types:
Simple metrics directly reference a measure. They can be thought of as a function accepting a single measure as input.Example:
metrics:
  - name: cancellations
    type: simple
    type_params:
      measure: cancellations_count
    filter: |
      {{ Dimension('order__value') }} > 100 and {{ Dimension('user__acquisition') }}
When creating metrics, maintain consistency in definitions. Avoid overlapping names and ambiguity to ensure clarity.

​
Conclusion

Metrics are crucial for deriving actionable insights. Understanding the various metric types and their definitions will enable you to build comprehensive data models.