Inventory Plans

view: inventory_plans {
  sql_table_name: inventory_plans ;;

  dimension: snapshot_week_start {
    type: date
    sql: DATE_ADD(${created_date},INTERVAL (0-(DAYOFWEEK(${created_date})+6)%7) DAY) ;;
  }

  dimension: id {
    type: int
    primary_key: yes
  }

  dimension: quantity {
    type: int
  }

  dimension: received_week_start {
    type: date
    sql: DATE_ADD(${receive_date},INTERVAL (0-(DAYOFWEEK(${receive_date})+6)%7) DAY) ;;
  }

  dimension: sku {
  }

  dimension: variant_id {
    type: int
  }

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

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

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }

  measure: total_quantity_planned {
    type: sum
    sql: ${quantity} ;;
  }
}

- view: inventory_plans
  sql_table_name: inventory_plans
  fields:
  - dimension: snapshot_week_start
    type: date
    sql: DATE_ADD(${created_date},INTERVAL (0-(DAYOFWEEK(${created_date})+6)%7) DAY)
  - dimension: id
    type: int
    primary_key: true
  - dimension: quantity
    type: int
  - dimension: received_week_start
    type: date
    sql: DATE_ADD(${receive_date},INTERVAL (0-(DAYOFWEEK(${receive_date})+6)%7) DAY)
  - dimension: sku
  - dimension: variant_id
    type: int
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: receive
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.receive_on
  - measure: count
    type: count_distinct
    sql: ${id}
  - measure: total_quantity_planned
    type: sum
    sql: ${quantity}