view: delivery_history {
  sql_table_name: art_relations.delivery_history ;;
#sql_table_name:ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.delivery_history ;;

  filter: encoder_id_filter {
    description: "(Encoder 18 is Vector 2.5)"
    type: number
    suggest_dimension: encoder_id
    sql: {% condition %} encoder_id {% endcondition %}
      ;;
  }

  measure: count_upc {
    label: "Number of Distinct UPCs"
    description: "Number of Distinct UPCs"
    type: count_distinct
    sql: ${TABLE}.upc ;;
  }

  dimension: delivery_id {
    type: number
    sql: ${TABLE}.delivery_id ;;
  }

  dimension: encoder_id {
    hidden: yes
    type: number
    sql: ${TABLE}.encoder_id ;;
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.upc ;;
  }

  dimension: customer_master_master_id {
    type: number
    label: "Store ID"
    sql: ${TABLE}.customer_master_master_id ;;
  }

  dimension: date_delivered {
    type: date
    sql: ${TABLE}.date_delivered ;;
  }

  measure: max_date_delivered {
    type: date
    sql: MAX(${TABLE}.date_delivered) ;;
  }

  measure: min_date_delivered {
    type: date
    sql: MIN(${TABLE}.date_delivered) ;;
  }

  dimension: package_size {
    hidden: yes
    type: number
    sql: ${TABLE}.package_size ;;
  }

  set: detail {
    fields: [
      delivery_id,
      encoder_id,
      upc,
      customer_master_master_id,
      date_delivered,
      package_size
    ]
  }
}