Migrate from Sigma

{
  "name": "Orders Model",
  "columns": [
    { "name": "Status", "formula": "[ORDERS/order_status]",
      "description": "Current fulfillment status of the order" },
    { "name": "Order Size",
      "formula": "If([Amount] >= 100, \"large\", [Amount] >= 20, \"medium\", \"small\")" }
  ],
  "metrics": [
    { "name": "Total Revenue", "formula": "Sum([Amount])",
      "format": { "type": "currency" } },
    { "name": "Cancelled Orders", "formula": "SumIf(1, [Status] = \"cancelled\")" },
    { "name": "Cancellation Rate",
      "formula": "Divide([Cancelled Orders], Count([Order Id])) * 100",
      "format": { "type": "percent" } }
  ],
  "relationships": [
    { "kind": "many-to-one", "target": { "path": ["SALES","PUBLIC","CUSTOMERS"] },
      "on": "[ORDERS/customer_id] = [CUSTOMERS/customer_id]" }
  ]
}

source: orders is conn.table('sales.orders') extend {
  primary_key: order_id
  join_one: customers is conn.table('sales.customers') on customer_id

  dimension:
    #(doc) Current fulfillment status of the order
    #(index)
    status is order_status

    #(doc) Order size bucket derived from amount
    order_size is
      pick 'large' when amount >= 100
      pick 'medium' when amount >= 20
      else 'small'

  measure:
    #(doc) Total revenue in USD
    # currency
    total_revenue is sum(amount)

    #(doc) Orders that were cancelled
    cancelled_orders is count() { where: status = 'cancelled' }

    #(doc) Percentage of orders that were cancelled
    # percent
    cancellation_rate is cancelled_orders / count() * 100

  view:
    #(doc) Monthly revenue trend
    monthly_revenue is {
      group_by: created_at.month
      aggregate: total_revenue
    }
}