LKML Manufacturing sanitary

O Stock Units Click Conv

O Stock Units Click Conv model for manufacturing sanitary.

inferred

Blocks

LKML LookML

o_stock_units_click_conv.view.lkml · 90 lines

inferred

view: o_stock_units_click_conv {
  sql_table_name: MS_EXCEL_Monthly_Rpt.Units ;;

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

  dimension: average_first_cost {
    sql: ${TABLE}."Average First Cost" ;;
  }

  dimension: brand {
    sql: ${TABLE}.Brand ;;
  }

  dimension: catg {
    sql: ${TABLE}.Catg ;;
  }

  dimension: conversion_ {
    sql: ${TABLE}."Conversion %" ;;
  }

  dimension: conversion__ly {
    sql: ${TABLE}."Conversion % LY" ;;
  }

  dimension: current_inventory {
    sql: ${TABLE}."Current Inventory" ;;
  }

  dimension: current_price {
    sql: ${TABLE}."Current Price" ;;
  }

  dimension: gms {
    sql: ${TABLE}.GMS ;;
  }

  dimension: gms_ly {
    sql: ${TABLE}."GMS LY" ;;
  }

  dimension: model_number {
    sql: ${TABLE}."Model Number" ;;
  }

  dimension: name {
    sql: ${TABLE}.Name ;;
  }

  dimension: product_page_views {
    sql: ${TABLE}."Product Page Views" ;;
  }

  dimension: product_page_views_ly {
    sql: ${TABLE}."Product Page Views LY" ;;
  }

  dimension: short_sku {
    sql: ${TABLE}."Short SKU" ;;
  }

  dimension: status {
    sql: ${TABLE}.Status ;;
  }

  dimension: subcatg {
    sql: ${TABLE}.Subcatg ;;
  }

  dimension: unit_sales {
    sql: ${TABLE}."Unit Sales" ;;
  }

  dimension: unit_sales_ly {
    sql: ${TABLE}."Unit Sales LY" ;;
  }

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

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

o_stock_units_click_conv.view.lookml · 50 lines

source-preserved

- view: o_stock_units_click_conv
  sql_table_name: MS_EXCEL_Monthly_Rpt.Units
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: average_first_cost
    sql: ${TABLE}."Average First Cost"
  - dimension: brand
    sql: ${TABLE}.Brand
  - dimension: catg
    sql: ${TABLE}.Catg
  - dimension: conversion_
    sql: ${TABLE}."Conversion %"
  - dimension: conversion__ly
    sql: ${TABLE}."Conversion % LY"
  - dimension: current_inventory
    sql: ${TABLE}."Current Inventory"
  - dimension: current_price
    sql: ${TABLE}."Current Price"
  - dimension: gms
    sql: ${TABLE}.GMS
  - dimension: gms_ly
    sql: ${TABLE}."GMS LY"
  - dimension: model_number
    sql: ${TABLE}."Model Number"
  - dimension: name
    sql: ${TABLE}.Name
  - dimension: product_page_views
    sql: ${TABLE}."Product Page Views"
  - dimension: product_page_views_ly
    sql: ${TABLE}."Product Page Views LY"
  - dimension: short_sku
    sql: ${TABLE}."Short SKU"
  - dimension: status
    sql: ${TABLE}.Status
  - dimension: subcatg
    sql: ${TABLE}.Subcatg
  - dimension: unit_sales
    sql: ${TABLE}."Unit Sales"
  - dimension: unit_sales_ly
    sql: ${TABLE}."Unit Sales LY"
  - dimension: upc
    sql: ${TABLE}.UPC
  - measure: count
    type: count
    drill_fields:
    - id
    - name

o_stock_units_click_conv.view.lkml
o_stock_units_click_conv.view.lookml

O Stock Units Click Conv

Blocks

Contents