LKML Manufacturing sanitary

Wayfair Product Sales Report Feb

Wayfair Product Sales Report Feb model for manufacturing sanitary.

inferred

Blocks

LKML LookML

wayfair_product_sales_report_feb.view.lkml · 89 lines

inferred

view: wayfair_product_sales_report_feb {
  sql_table_name: MS_EXCEL_Sales_Report.Sheet2 ;;

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

  dimension: sale_date {
    sql: ${TABLE}."Date of Sale/Purchase" ;;
  }

  dimension: distributor_name {
    sql: ${TABLE}."Distributor Name" ;;
  }

  dimension: product_sku_ {
    sql: ${TABLE}."Kohler Sku ;;
  }

  dimension: price_ea {
    sql: CAST(${TABLE}."Price Ea" AS FLOAT) ;;
  }

  dimension: product_description {
    sql: ${TABLE}."Product Description" ;;
  }

  dimension: quantity_sold {
    sql: CAST(${TABLE}."Quantity Sold" AS FLOAT) ;;
  }

  dimension: sales {
    sql: CAST(${TABLE}."Sales $" AS FLOAT) ;;
  }

  dimension: ship_date {
    sql: ${TABLE}."Ship Date" ;;
  }

  dimension: ship_to_zipcode {
    sql: ${TABLE}."Ship to Zipcode" ;;
  }

  dimension: total_price_order {
    sql: CAST(${TABLE}."Total Price" AS FLOAT) ;;
  }

  dimension: total_sales_order {
    sql: CAST(${TABLE}."Total Sales" AS FLOAT) ;;
  }

  dimension: upc {
    sql: ${TABLE}.UPC ;;
  }

  dimension: wayfair_order_ {
    sql: ${TABLE}."Wayfair Order ;;
  }

  dimension: wayfair_po_ {
    sql: ${TABLE}."Wayfair PO ;;
  }

  dimension: wayfair_sku_ {
    sql: ${TABLE}."Wayfair Sku ;;
  }

  measure: total_price {
    type: sum
    sql: ${total_price_order} ;;
  }

  measure: total_quantity_sold {
    type: sum
    sql: ${quantity_sold} ;;
  }

  measure: total_sales {
    type: sum
    sql: ${total_sales_order} ;;
  }

  measure: count {
    type: count
    drill_fields: [id, distributor_name]
  }
}

wayfair_product_sales_report_feb.view.lookml · 51 lines

source-preserved

- view: wayfair_product_sales_report_feb
  sql_table_name: MS_EXCEL_Sales_Report.Sheet2
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: sale_date
    sql: ${TABLE}."Date of Sale/Purchase"
  - dimension: distributor_name
    sql: ${TABLE}."Distributor Name"
  - dimension: product_sku_
    sql: ${TABLE}."Kohler Sku
  - dimension: price_ea
    sql: CAST(${TABLE}."Price Ea" AS FLOAT)
  - dimension: product_description
    sql: ${TABLE}."Product Description"
  - dimension: quantity_sold
    sql: CAST(${TABLE}."Quantity Sold" AS FLOAT)
  - dimension: sales
    sql: CAST(${TABLE}."Sales $" AS FLOAT)
  - dimension: ship_date
    sql: ${TABLE}."Ship Date"
  - dimension: ship_to_zipcode
    sql: ${TABLE}."Ship to Zipcode"
  - dimension: total_price_order
    sql: CAST(${TABLE}."Total Price" AS FLOAT)
  - dimension: total_sales_order
    sql: CAST(${TABLE}."Total Sales" AS FLOAT)
  - dimension: upc
    sql: ${TABLE}.UPC
  - dimension: wayfair_order_
    sql: ${TABLE}."Wayfair Order
  - dimension: wayfair_po_
    sql: ${TABLE}."Wayfair PO
  - dimension: wayfair_sku_
    sql: ${TABLE}."Wayfair Sku
  - measure: total_price
    type: sum
    sql: ${total_price_order}
  - measure: total_quantity_sold
    type: sum
    sql: ${quantity_sold}
  - measure: total_sales
    type: sum
    sql: ${total_sales_order}
  - measure: count
    type: count
    drill_fields:
    - id
    - distributor_name

wayfair_product_sales_report_feb.view.lkml
wayfair_product_sales_report_feb.view.lookml

Wayfair Product Sales Report Feb

Blocks

Contents