Order Lines

view: order_lines {
  sql_table_name: OrderLines ;;

  dimension: order_line_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.OrderLineID ;;
  }

  dimension: discount {
    type: number
    hidden: yes
    sql: ${TABLE}.Discount ;;
  }

  dimension: dispatch_id {
    type: int
    hidden: yes
    sql: ${TABLE}.DispatchID ;;
  }

  dimension: order_id {
    hidden: yes
    sql: ${TABLE}.OrderID ;;
  }

  dimension: order_line_status {
    type: int
    sql: ${TABLE}.OrderLineStatus ;;
  }

  dimension: payment_status {
    type: int
    sql: ${TABLE}.PaymentStatus ;;
  }

  dimension: price {
    type: number
    hidden: yes
    sql: ${TABLE}.Price ;;
  }

  dimension: product_id {
    type: int
    sql: ${TABLE}.ProductID ;;
  }

  dimension: quantity {
    type: number
    sql: ${TABLE}.Quantity ;;
  }

  dimension: refund_amount {
    type: number
    sql: ${TABLE}.RefundAmount ;;
  }

  dimension: vatrate {
    type: number
    sql: ${TABLE}.VATRate ;;
  }

  measure: total_price_amount {
    type: sum
    sql: ${price} ;;
  }

  measure: average_price_amount {
    type: average
    sql: ${price} ;;
  }

  measure: total_quantity {
    type: sum
    sql: ${quantity} ;;
  }

  measure: count {
    type: count
  }

  measure: percent_of_previous_quantity {
    type: percent_of_previous
    sql: ${count} ;;
  }

  measure: percent_of_total_quantity {
    type: percent_of_total
    sql: ${count} ;;
  }

  measure: total_discount_amount {
    type: sum
    sql: ${discount} ;;
  }

  measure: average_discount_amount {
    type: average
    sql: ${discount} ;;
  }

  measure: total_refund_amount {
    type: sum
    sql: ${refund_amount} ;;
  }
}

- view: order_lines
  sql_table_name: OrderLines
  fields:
  - dimension: order_line_id
    type: int
    primary_key: true
    sql: ${TABLE}.OrderLineID
  - dimension: discount
    type: number
    hidden: true
    sql: ${TABLE}.Discount
  - dimension: dispatch_id
    type: int
    hidden: true
    sql: ${TABLE}.DispatchID
  - dimension: order_id
    hidden: true
    sql: ${TABLE}.OrderID
  - dimension: order_line_status
    type: int
    sql: ${TABLE}.OrderLineStatus
  - dimension: payment_status
    type: int
    sql: ${TABLE}.PaymentStatus
  - dimension: price
    type: number
    hidden: true
    sql: ${TABLE}.Price
  - dimension: product_id
    type: int
    sql: ${TABLE}.ProductID
  - dimension: quantity
    type: number
    sql: ${TABLE}.Quantity
  - dimension: refund_amount
    type: number
    sql: ${TABLE}.RefundAmount
  - dimension: vatrate
    type: number
    sql: ${TABLE}.VATRate
  - measure: total_price_amount
    type: sum
    sql: ${price}
  - measure: average_price_amount
    type: average
    sql: ${price}
  - measure: total_quantity
    type: sum
    sql: ${quantity}
  - measure: count
    type: count
  - measure: percent_of_previous_quantity
    type: percent_of_previous
    sql: ${count}
  - measure: percent_of_total_quantity
    type: percent_of_total
    sql: ${count}
  - measure: total_discount_amount
    type: sum
    sql: ${discount}
  - measure: average_discount_amount
    type: average
    sql: ${discount}
  - measure: total_refund_amount
    type: sum
    sql: ${refund_amount}