data.ml
LookML Ecommerce mattresses

Sale Allowances

Sale Allowances model for ecommerce mattresses.

source-preserved

Blocks

sale_allowances.view.lkml · 35 lines
inferred 
view: sale_allowances {
  sql_table_name: Sale_Allowances ;;

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

  dimension: amount {
    sql: ${TABLE}.Amount ;;
  }

  dimension: code {
    sql: ${TABLE}.Code ;;
  }

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

  dimension: points {
    sql: ${TABLE}.Points ;;
  }

  dimension: sale_id {
    type: int
    sql: ${TABLE}.Sale_Id ;;
  }

  measure: count {
    type: count
    drill_fields: [id, sales.id]
  }
}
sale_allowances.view.lookml · 23 lines
source-preserved 
- view: sale_allowances
  sql_table_name: Sale_Allowances
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: amount
    sql: ${TABLE}.Amount
  - dimension: code
    sql: ${TABLE}.Code
  - dimension: ohm_id
    sql: ${TABLE}.OHM_Id
  - dimension: points
    sql: ${TABLE}.Points
  - dimension: sale_id
    type: int
    sql: ${TABLE}.Sale_Id
  - measure: count
    type: count
    drill_fields:
    - id
    - sales.id

Contents

  • sale_allowances.view.lkml
  • sale_allowances.view.lookml