view: int_dbt_prod_advertising_monthly_requests_cleaned {
  sql_table_name: intelligence.dbt_prod.advertising_monthly_requests_cleaned ;;

  dimension: sql_distinct_key {
    primary_key: yes
    hidden: yes
    description: "Primary Key"
    sql: CONCAT(
    COALESCE(CAST(${TABLE}.form_month AS VARCHAR), '___NULL___'), '||',
    COALESCE(${TABLE}.label_id, '___NULL___'), '||',
    COALESCE(${TABLE}.service_type, '___NULL___'), '||',
    COALESCE(${TABLE}.label_manager_country, '___NULL___'), '||',
    COALESCE(${TABLE}.payment, '___NULL___'), '||',
    COALESCE(${TABLE}.territory_assignment, '___NULL___')
    ) ;;
  }

  measure: budget {
    view_label: "Requests"
    type: sum
    sql: ${TABLE}.BUDGET ;;
    value_format:"$#,##0"
  }

  dimension_group: form_month {
    type: time
    view_label: "Requests"
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.FORM_MONTH ;;
  }

  dimension: label_id {
    view_label: "Label"
    label: "Label Id"
    type: string
    sql: ${TABLE}.LABEL_ID ;;
  }

  dimension: service_type {
    view_label: "Requests"
    label: "Service Type"
    type: string
    sql: ${TABLE}.service_type ;;
  }

  dimension: label_manager_country {
    view_label: "Relationship Manager"
    label: "Relationship Manager Country"
    type: string
    sql: ${TABLE}.LABEL_MANAGER_COUNTRY ;;
  }

  dimension: payment {
    view_label: "Accounting"
    type: string
    sql: ${TABLE}.PAYMENT ;;
  }

  measure: prev_month_budget {
    view_label: "Requests"
    label: "Budget (Previous Month)"
    type: sum
    sql: ${TABLE}.PREV_MONTH_BUDGET ;;
    value_format:"$#,##0"
  }

  measure: prev_month_total_requests {
    view_label: "Requests"
    label: "Requests (Previous Month)"
    type: sum
    sql: ${TABLE}.PREV_MONTH_TOTAL_REQUESTS ;;
  }

  measure: same_month_prev_year_budget {
    view_label: "Requests"
    label: "Budget (Same Month, Previous Year)"
    type: sum
    sql: ${TABLE}.SAME_MONTH_PREV_YEAR_BUDGET ;;
    value_format:"$#,##0"
  }

  measure: same_month_prev_year_total_requests {
    view_label: "Requests"
    label: "Requests (Same Month, Previous Year)"
    type: sum
    sql: ${TABLE}.SAME_MONTH_PREV_YEAR_TOTAL_REQUESTS ;;
  }

  dimension: territory_assignment {
    view_label: "Campaign Details"
    label: "Territory Assignment"
    type: string
    sql: ${TABLE}.TERRITORY_ASSIGNMENT ;;
  }

  measure: total_requests {
    view_label: "Requests"
    label: "Requests"
    type: sum
    sql: ${TABLE}.TOTAL_REQUESTS ;;
  }

  dimension: total_requests_viz {
    view_label: "DO NOT USE"
    label: "Requests"
    #hidden: yes
    type: number
    sql: ${TABLE}.TOTAL_REQUESTS ;;
  }

  dimension: prev_month_label_with_requests {
    view_label: "DO NOT USE"
    label: "Label Id with Request in Previous Month"
    #hidden: yes
    type: string
    sql: ${TABLE}.prev_month_label_with_request ;;
  }

  dimension: same_month_prev_year_label_with_request {
    view_label: "DO NOT USE"
    label: "Label Id with Request in Same Month, Previous Year"
    #hidden: yes
    type: string
    sql: ${TABLE}.same_month_prev_year_label_with_request ;;
  }

  dimension: ltm_label_with_request {
    view_label: "DO NOT USE"
    label: "Label Id with Request in LTM"
    #hidden: yes
    type: string
    sql: ${TABLE}.ltm_label_with_request ;;
  }

  dimension: fytd_label_with_request {
    view_label: "DO NOT USE"
    label: "Label Id with Request in FYTD"
    #hidden: yes
    type: string
    sql: ${TABLE}.fytd_label_with_request ;;
  }

  dimension: prev_ltm_label_with_request {
    view_label: "DO NOT USE"
    label: "Label Id with Request in Previous LTM"
    #hidden: yes
    type: string
    sql: ${TABLE}.prev_ltm_label_with_request ;;
  }

  dimension: prev_fytd_label_with_request {
    view_label: "DO NOT USE"
    label: "Label Id with Request in Previous FYTD"
    #hidden: yes
    type: string
    sql: ${TABLE}.prev_fytd_label_with_request ;;
  }

  measure: ltm_total_requests {
    view_label: "Requests"
    label: "Requests (LTM)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.ltm_total_requests ;;
  }

  measure: fytd_total_requests {
    view_label: "Requests"
    label: "Requests (FYTD)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.fytd_total_requests ;;
  }

  measure: ltm_budget {
    view_label: "Requests"
    label: "Budget (LTM)"
    #hidden: yes
    type: sum
    value_format:"$#,##0"
    sql: ${TABLE}.ltm_budget ;;
  }

  measure: fytd_budget {
    view_label: "Requests"
    label: "Budget (FYTD)"
    #hidden: yes
    type: sum
    value_format:"$#,##0"
    sql: ${TABLE}.fytd_budget ;;
  }

  measure: prev_ltm_total_requests {
    view_label: "Requests"
    label: "Requests (Previous LTM)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.prev_ltm_total_requests ;;
  }

  measure: prev_fytd_total_requests {
    view_label: "Requests"
    label: "Requests (Previous FYTD)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.prev_fytd_total_requests ;;
  }

  measure: prev_ltm_budget {
    view_label: "Requests"
    label: "Budget (Previous LTM)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.prev_ltm_budget ;;
    value_format:"$#,##0"
  }

  measure: prev_fytd_budget {
    view_label: "Requests"
    label: "Budget (Previous FYTD)"
    #hidden: yes
    type: sum
    sql: ${TABLE}.prev_fytd_budget ;;
    value_format:"$#,##0"
  }


}