Migrate from Cube

cubes:
  - name: orders
    sql_table: sales.orders
    description: All customer orders
    joins:
      - name: customers
        relationship: many_to_one
        sql: "{CUBE.customer_id} = {customers.customer_id}"
    dimensions:
      - name: order_id
        sql: order_id
        type: number
        primary_key: true
      - name: status
        description: Current fulfillment status of the order
        sql: order_status
        type: string
    measures:
      - name: total_revenue
        description: Total revenue in USD
        sql: amount
        type: sum
        format: currency
      - name: cancelled_orders
        type: count
        filters:
          - sql: "{CUBE}.status = 'cancelled'"
      - name: cancellation_rate
        sql: "1.0 * {cancelled_orders} / NULLIF({count}, 0) * 100"
        type: number
        format: percent
    pre_aggregations:              # dropped — engine acceleration
      - name: orders_rollup
        measures: [count, total_revenue]
        time_dimension: created_at
        granularity: day

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

  measure:
    #(doc) Number of orders
    order_count is count()

    #(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 / order_count * 100

  view:
    #(doc) Daily orders and revenue trend
    daily_orders is {
      group_by: created_at.day
      aggregate: order_count, total_revenue
    }
}