view: dt_itunes_ticket_within_window {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_ITUNES_TICKET_WITHIN_WINDOW ;;

  dimension: upc {
    type: string
    sql: ${TABLE}.upc ;;
    primary_key: yes
    hidden: yes
  }

  dimension: date_first_delivered {
    type: date
    sql: ${TABLE}.date_first_delivered ;;
    view_label: "Release"
  }

  dimension: ticket_window {
    type: number
    sql: DATEDIFF(day, ${TABLE}.date_first_delivered, TO_DATE(${facts_prod_itunes_tickets.created_date}))  ;;
    view_label: "iTunes Ticket"
  }

  dimension: within_window {
    type: yesno
    sql: DATEDIFF(day, ${TABLE}.date_first_delivered, TO_DATE(${facts_prod_itunes_tickets.created_date})) <= 90  ;;
    view_label: "iTunes Ticket"
  }

}