Metrics

​

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:

​

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:

metrics:
  - name: cancellations
    type: simple
    type_params:
      measure: cancellations_count
    filter: |
      {{ Dimension('order__value') }} > 100 and {{ Dimension('user__acquisition') }}

metrics:
  - name: cancellations
    type: simple
    type_params:
      measure: cancellations_count
    filter: |
      {{ Dimension('order__value') }} > 100 and {{ Dimension('user__acquisition') }}

metrics:
  - name: wau_rolling_7
    type: cumulative
    type_params:
      measures:
        - distinct_users
      window: 7 days

metrics:
  - name: order_gross_profit
    type: derived
    type_params:
      expr: revenue - cost
      metrics:
        - name: order_total
          alias: revenue
        - name: order_cost
          alias: cost

metrics:
  - name: cancellation_rate
    type: ratio
    type_params:
      numerator: cancellations
      denominator: transaction_amount

​

Conclusion

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