view: facts_prod_fact_conflict {
  sql_table_name: facts.prod.fact_conflict ;;

  # PRIMARY KEY
  dimension: conflict_id {
    type: number
    sql: ${TABLE}.conflict_id ;;
    primary_key: yes
  }

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

  dimension_group: conflictdate {
    type: time
    timeframes: [date, week, month, year]
    view_label: "Conflict"
    label: "Conflict"
    sql: ${TABLE}.conflict_date ;;
  }

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

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

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

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

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

  dimension: processed_datetime {
    type: date_time
    sql: ${TABLE}.processed_datetime ;;
  }

  dimension: resolved_datetime {
    type: date_time
    sql: ${TABLE}.resolved_datetime ;;
  }

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

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

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

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

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

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

  measure: number_of_conflicts {
    type: count_distinct
    label: "Number of Conflicts"
    view_label: "Conflict"
    sql: ${conflict_id} ;;
  }

  measure: number_of_clients {
    type: count_distinct
    label: "Number of Clients"
    view_label: "Conflict"
    sql: ${vendor_id} ;;
  }

}