view: facts_prod_itunes_tickets {
  sql_table_name: facts.prod.itunes_tickets ;;

  dimension: file_date {
    type: date
    sql: ${TABLE}.file_date ;;
    view_label: "File"
    description: "Generated internally by The Orchard to capture the date a file was downloaded from iTunes."
  }

  dimension: ticketid {
    label: "Ticket ID"
    type: string
    sql: ${TABLE}.ticketid ;;
    # value_format: "0"
  }

  dimension: contentadamid {
    label: "Apple ID"
    type: number
    sql: ${TABLE}.contentadamid ;;
    value_format: "0"
  }

  dimension: contentgenre {
    label: "Genre"
    type: string
    sql: ${TABLE}.contentgenre ;;
  }

  dimension: contentlanguage {
    label: "Language"
    type: string
    sql: ${TABLE}.contentlanguage ;;
  }

  dimension: contentprovider {
    label: "Content Provider"
    type: string
    sql: ${TABLE}.contentprovider ;;
  }

  dimension: contentticketstate {
    label: "Ticket State"
    type: string
    sql: ${TABLE}.contentticketstate ;;
  }

  dimension: contenttickettype {
    label: "Ticket Type"
    type: string
    sql: ${TABLE}.contenttickettype ;;
  }

  dimension: contenttype {
    label: "Content Type"
    type: string
    sql: ${TABLE}.contenttype ;;
  }

  dimension: contentupc {
    label: "UPC"
    type: string
    sql: ${TABLE}.contentupc ;;
  }

  dimension: contentvendorid {
    label: "Vendor ID"
    type: string
    sql: ${TABLE}.contentvendorid ;;
  }

  dimension_group: created {
    type: time
    sql: ${TABLE}.created ;;
  }

  dimension: discnumber {
    label: "Disc Number"
    type: number
    sql: ${TABLE}.discnumber ;;
  }

  dimension: last_modified {
    type: date
    sql: ${TABLE}.lastmodified ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.name ;;
  }

  dimension: openedby {
    label: "Opened By"
    type: string
    sql: ${TABLE}.openedby ;;
  }

  dimension: orchard_upc {
    type: string
    sql: TRY_TO_NUMERIC(COALESCE(${TABLE}.contentupc, ${TABLE}.contentvendorid)) ;; # TRY_TO_NUMERIC(${TABLE}.orchard_upc)
    hidden: yes
  }

  dimension: tracknumber {
    label: "Track Number"
    type: number
    sql: ${TABLE}.tracknumber ;;
  }

  measure: count_tickets {
    type: count_distinct
    sql: ${TABLE}.ticketId ;;
    label: "Tickets (Count)"
  }
}