Sales

view: sales {
  sql_table_name: Sales ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.Id ;;
  }

  dimension: ar_invoice_id {
    type: int
    sql: ${TABLE}.ArInvoice_Id ;;
  }

  dimension: charge_id {
    sql: ${TABLE}.Charge_Id ;;
  }

  dimension: commission_amount {
    type: number
    sql: ${TABLE}.Commission_Amount ;;
  }

  dimension: commission_percent {
    type: number
    sql: ${TABLE}.Commission_Percent ;;
  }

  dimension: customer_id {
    type: int
    sql: ${TABLE}.Customer_Id ;;
  }

  dimension: customer_reference {
    sql: ${TABLE}.Customer_Reference ;;
  }

  dimension: description {
    sql: ${TABLE}.Description ;;
  }

  dimension: discount_amount {
    type: number
    sql: ${TABLE}.Discount_Amount ;;
  }

  dimension: entity {
    type: yesno
    sql: ${TABLE}.Entity ;;
  }

  dimension: facility {
    type: yesno
    sql: ${TABLE}.Facility ;;
  }

  dimension: floor_sample_discount_percent {
    sql: ${TABLE}.Floor_Sample_Discount_Percent ;;
  }

  dimension: gl_account_id {
    type: int
    sql: ${TABLE}.GlAccount_Id ;;
  }

  dimension: gl_company {
    sql: ${TABLE}.GlCompany ;;
  }

  dimension: item_number {
    sql: ${TABLE}.Item_Number ;;
  }

  dimension: item_type {
    type: yesno
    sql: ${TABLE}.Item_Type ;;
  }

  dimension: list_price_amount {
    type: number
    sql: ${TABLE}.List_Price_Amount ;;
  }

  dimension: model_configuration {
    sql: ${TABLE}.Model_Configuration ;;
  }

  dimension: model_id {
    type: int
    sql: ${TABLE}.Model_Id ;;
  }

  dimension: next_sequence_number {
    sql: ${TABLE}.Next_Sequence_Number ;;
  }

  dimension: ohm_id {
    sql: ${TABLE}.OHM_Id ;;
  }

  dimension: order_class {
    type: yesno
    sql: ${TABLE}.Order_Class ;;
  }

  dimension: order_type {
    type: yesno
    sql: ${TABLE}.Order_Type ;;
  }

  dimension: part_id {
    type: int
    sql: ${TABLE}.Part_Id ;;
  }

  dimension: posted {
    sql: ${TABLE}.Posted ;;
  }

  dimension: posted_customer_bank {
    sql: ${TABLE}.Posted_Customer_Bank ;;
  }

  dimension: posted_statistics {
    sql: ${TABLE}.Posted_Statistics ;;
  }

  dimension: price_code {
    sql: ${TABLE}.Price_Code ;;
  }

  dimension: price_list_id {
    type: int
    sql: ${TABLE}.PriceList_Id ;;
  }

  dimension: program_data {
    sql: ${TABLE}.Program_Data ;;
  }

  dimension: record_type {
    sql: ${TABLE}.Record_Type ;;
  }

  dimension: return_reason {
    type: number
    sql: ${TABLE}.Return_Reason ;;
  }

  dimension: rma_number {
    sql: ${TABLE}.RMA_Number ;;
  }

  dimension: sales_amount {
    type: number
    sql: ${TABLE}.Sales_Amount ;;
  }

  dimension: sales_amount_tiered {
    type: tier
    sql: ${sales_amount} ;;
  }

  dimension: sales_cost {
    type: number
    sql: ${TABLE}.Sales_Cost ;;
  }

  dimension: sales_division_id {
    type: int
    sql: ${TABLE}.SalesDivision_Id ;;
  }

  dimension: sales_order {
    sql: ${TABLE}.Sales_Order ;;
  }

  dimension: sales_person_id {
    type: int
    sql: ${TABLE}.SalesPerson_Id ;;
  }

  dimension: sales_pieces {
    type: int
    sql: ${TABLE}.Sales_Pieces ;;
  }

  dimension: sales_product_id {
    type: int
    sql: ${TABLE}.SalesProduct_Id ;;
  }

  dimension: sales_promotion_code {
    sql: ${TABLE}.Sales_Promotion_Code ;;
  }

  dimension: sales_quantity {
    type: int
    sql: ${TABLE}.Sales_Quantity ;;
  }

  dimension: sales_rep_id {
    type: int
    sql: ${TABLE}.SalesRep_Id ;;
  }

  dimension: shipment_number {
    sql: ${TABLE}.Shipment_Number ;;
  }

  dimension: store_id {
    type: int
    sql: ${TABLE}.Store_Id ;;
  }

  dimension: unit_of_measure_id {
    type: int
    sql: ${TABLE}.UnitOfMeasure_Id ;;
  }

  dimension_group: invoice {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Invoice_Date ;;
  }

  dimension_group: order {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Order_Date ;;
  }

  dimension_group: promise {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Promise_Date ;;
  }

  dimension_group: request {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Request_Date ;;
  }

  dimension_group: ship {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.Ship_Date ;;
  }

  measure: count {
    type: count
    drill_fields: [customers.name, count]
  }

  measure: sales_amount_total {
    type: sum
    value_format: "[>=1000000]$0.00,,\"M\";[>=1000]$0.00,\"K\";$0.00"
    sql: ${sales_amount} ;;
  }

  measure: avg_sale_amount {
    type: average
    value_format: "$#,##0"
    sql: ${sales_amount} ;;
  }

  measure: sales_quantity_total {
    type: sum
    sql: ${sales_quantity} ;;
  }

  measure: average_sales_rep_amount {
    type: number
    value_format: "[>=1000000]$0.00,,\"M\";[>=1000]$0.00,\"K\";$0.00"
    sql: ${sales.sales_amount_total} / ${sales_reps.count} ;;
  }
}

- view: sales
  sql_table_name: Sales
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: ar_invoice_id
    type: int
    sql: ${TABLE}.ArInvoice_Id
  - dimension: charge_id
    sql: ${TABLE}.Charge_Id
  - dimension: commission_amount
    type: number
    sql: ${TABLE}.Commission_Amount
  - dimension: commission_percent
    type: number
    sql: ${TABLE}.Commission_Percent
  - dimension: customer_id
    type: int
    sql: ${TABLE}.Customer_Id
  - dimension: customer_reference
    sql: ${TABLE}.Customer_Reference
  - dimension: description
    sql: ${TABLE}.Description
  - dimension: discount_amount
    type: number
    sql: ${TABLE}.Discount_Amount
  - dimension: entity
    type: yesno
    sql: ${TABLE}.Entity
  - dimension: facility
    type: yesno
    sql: ${TABLE}.Facility
  - dimension: floor_sample_discount_percent
    sql: ${TABLE}.Floor_Sample_Discount_Percent
  - dimension: gl_account_id
    type: int
    sql: ${TABLE}.GlAccount_Id
  - dimension: gl_company
    sql: ${TABLE}.GlCompany
  - dimension: item_number
    sql: ${TABLE}.Item_Number
  - dimension: item_type
    type: yesno
    sql: ${TABLE}.Item_Type
  - dimension: list_price_amount
    type: number
    sql: ${TABLE}.List_Price_Amount
  - dimension: model_configuration
    sql: ${TABLE}.Model_Configuration
  - dimension: model_id
    type: int
    sql: ${TABLE}.Model_Id
  - dimension: next_sequence_number
    sql: ${TABLE}.Next_Sequence_Number
  - dimension: ohm_id
    sql: ${TABLE}.OHM_Id
  - dimension: order_class
    type: yesno
    sql: ${TABLE}.Order_Class
  - dimension: order_type
    type: yesno
    sql: ${TABLE}.Order_Type
  - dimension: part_id
    type: int
    sql: ${TABLE}.Part_Id
  - dimension: posted
    sql: ${TABLE}.Posted
  - dimension: posted_customer_bank
    sql: ${TABLE}.Posted_Customer_Bank
  - dimension: posted_statistics
    sql: ${TABLE}.Posted_Statistics
  - dimension: price_code
    sql: ${TABLE}.Price_Code
  - dimension: price_list_id
    type: int
    sql: ${TABLE}.PriceList_Id
  - dimension: program_data
    sql: ${TABLE}.Program_Data
  - dimension: record_type
    sql: ${TABLE}.Record_Type
  - dimension: return_reason
    type: number
    sql: ${TABLE}.Return_Reason
  - dimension: rma_number
    sql: ${TABLE}.RMA_Number
  - dimension: sales_amount
    type: number
    sql: ${TABLE}.Sales_Amount
  - dimension: sales_amount_tiered
    type: tier
    sql: ${sales_amount}
  - dimension: sales_cost
    type: number
    sql: ${TABLE}.Sales_Cost
  - dimension: sales_division_id
    type: int
    sql: ${TABLE}.SalesDivision_Id
  - dimension: sales_order
    sql: ${TABLE}.Sales_Order
  - dimension: sales_person_id
    type: int
    sql: ${TABLE}.SalesPerson_Id
  - dimension: sales_pieces
    type: int
    sql: ${TABLE}.Sales_Pieces
  - dimension: sales_product_id
    type: int
    sql: ${TABLE}.SalesProduct_Id
  - dimension: sales_promotion_code
    sql: ${TABLE}.Sales_Promotion_Code
  - dimension: sales_quantity
    type: int
    sql: ${TABLE}.Sales_Quantity
  - dimension: sales_rep_id
    type: int
    sql: ${TABLE}.SalesRep_Id
  - dimension: shipment_number
    sql: ${TABLE}.Shipment_Number
  - dimension: store_id
    type: int
    sql: ${TABLE}.Store_Id
  - dimension: unit_of_measure_id
    type: int
    sql: ${TABLE}.UnitOfMeasure_Id
  - dimension_group: invoice
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Invoice_Date
  - dimension_group: order
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Order_Date
  - dimension_group: promise
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Promise_Date
  - dimension_group: request
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Request_Date
  - dimension_group: ship
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.Ship_Date
  - measure: count
    type: count
    drill_fields:
    - customers.name
    - count
  - measure: sales_amount_total
    type: sum
    value_format: '[>=1000000]$0.00,,"M";[>=1000]$0.00,"K";$0.00'
    sql: ${sales_amount}
  - measure: avg_sale_amount
    type: average
    value_format: '$#,##0'
    sql: ${sales_amount}
  - measure: sales_quantity_total
    type: sum
    sql: ${sales_quantity}
  - measure: average_sales_rep_amount
    type: number
    value_format: '[>=1000000]$0.00,,"M";[>=1000]$0.00,"K";$0.00'
    sql: ${sales.sales_amount_total} / ${sales_reps.count}