Migrate from Omni

# order_items.view
views:
  - name: order_items
    sql_table_name: analytics.public.order_items
    dimensions:
      status:
        type: string
        sql: ${TABLE}.order_status
      value_tier:
        type: string
        sql: |
          CASE WHEN ${TABLE}.sale_price >= 100 THEN 'High'
               WHEN ${TABLE}.sale_price >= 25  THEN 'Medium'
               ELSE 'Low' END
    measures:
      total_revenue:
        description: Gross merchandise value across all order items
        sql: ${TABLE}.sale_price
        aggregate_type: sum
      completed_revenue:
        sql: ${TABLE}.sale_price
        aggregate_type: sum
        filters: { status: { is: Complete } }
      order_count:
        sql: ${TABLE}.order_id
        aggregate_type: count_distinct

source: order_items is conn.table('analytics.public.order_items') extend {
  primary_key: order_item_id
  join_one: users is conn.table('analytics.public.users') on user_id

  dimension:
    #(doc) Order item status
    #(index)
    status is order_status

    #(doc) Sale-price value bucket
    value_tier is
      pick 'High' when sale_price >= 100
      pick 'Medium' when sale_price >= 25
      else 'Low'

  measure:
    #(doc) Gross merchandise value across all order items
    # currency
    total_revenue is sum(sale_price)

    #(doc) Recognized revenue from completed items
    # currency
    completed_revenue is sum(sale_price) { where: status = 'Complete' }

    #(doc) Distinct orders
    order_count is count(order_id)

    #(doc) Average order value
    # currency
    avg_order_value is total_revenue / order_count

  view:
    #(doc) Revenue by month
    revenue_by_month is {
      group_by: created_at.month
      aggregate: total_revenue
    }
}