data.ml
LKML Ecommerce fashion

Return Authorizations

Return Authorizations model for ecommerce fashion.

inferred

Blocks

return_authorizations.view.lkml · 72 lines
inferred 
view: return_authorizations {
  sql_table_name: store_return_authorizations ;;

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

  dimension: memo {
    sql: ${TABLE}.memo ;;
  }

  dimension: authorization_number {
    sql: ${TABLE}.number ;;
  }

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

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

  dimension: state {
    sql: ${TABLE}.state ;;
  }

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

  dimension: is_entire_order_returned {
    type: yesno
    sql: ${orders.state}='complete_return' ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month, year]
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [time, date, week, month, year]
    sql: ${TABLE}.updated_at ;;
  }

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

  measure: full_order_returned_count {
    type: count
    filters: [is_entire_order_returned: "yes"]
  }

  measure: part_of_order_returned_count {
    type: count
    filters: [is_entire_order_returned: "no"]
  }
}
return_authorizations.view.lookml · 59 lines
source-preserved 
- view: return_authorizations
  sql_table_name: store_return_authorizations
  fields:
  - dimension: id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: memo
    sql: ${TABLE}.memo
  - dimension: authorization_number
    sql: ${TABLE}.number
  - dimension: order_id
    type: int
    hidden: true
    sql: ${TABLE}.order_id
  - dimension: return_authorization_reason_id
    type: int
    hidden: true
    sql: ${TABLE}.return_authorization_reason_id
  - dimension: state
    sql: ${TABLE}.state
  - dimension: stock_location_id
    type: int
    hidden: true
    sql: ${TABLE}.stock_location_id
  - dimension: is_entire_order_returned
    type: yesno
    sql: ${orders.state}='complete_return'
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
  - measure: full_order_returned_count
    type: count
    filters:
    - is_entire_order_returned: yes
  - measure: part_of_order_returned_count
    type: count
    filters:
    - is_entire_order_returned: no

Contents

  • return_authorizations.view.lkml
  • return_authorizations.view.lookml