Ability to define Metrics and attach them to Entities

Is your feature request related to a problem? Please describe.

It is difficult to know which metrics are the source of truth in my organization for defining core KPIs or other critical measurements of success.

Describe the solution you'd like

As an end-user of DataHub, I want to be able to define and govern Metrics/KPIs for my organization and attach them to relevant Entities (Datasets, Dashboards, Charts, etc.)

I should be able to provide a plain-language definition of what is being measured, along with any additional transformation/filtering logic associated with it.

For example, let’s say I want to define Annual Net Revenue by Customer as a metric, I want to be able to define the following:

Metric Name: Annual Net Revenue by Customer

Description: The total price charged, less the amount paid for shipping for all completed orders, grouped by Customer Name. Orders must have been created by the customer in the past 365 days.

Sample Code:

select
  customer_name
  , sum(price) - sum(shipping_cost) as net_revenue
from
  orders
where
  status = 'completed'
  and created_at >= getdate() - interval '356 days'
group by 1

I would like to be able to attach this Metric to the orders Dataset, along with associated Charts & Dashboards.