dbt_metric.sql

 - name: revenue
   label: Revenue
   model: ref('revenue_all')
  
   calculation_method: sum
   expression: price * quantity
 
   timestamp: date
   time_grains: [day, week, month, quarter, year]
 
   dimensions: [
             order_id,
             order_status,
             date,
             campaign_id,
             customer_id,
             product_id,
             price,
             quantity,
             customer_name,
             state,
             region,
             product_name,
             category
   ]
 
   filters:
     - field: order_status
       operator: '='
       value: "'Delivered'"