view: int_dbt_prod_label_performance_spreadsheet {
  sql_table_name: INTELLIGENCE.DBT_PROD.LABEL_PERFORMANCE_SPREADSHEET ;;

  dimension: label_manager {
    type: string
    view_label: "Label"
    label: "Label Manager"
    sql: ${TABLE}.label_manager;;
  }

  dimension: label_id {
    type: number
    view_label: "Label"
    label: "Label ID"
    sql: ${TABLE}.label_id;;
  }

  dimension: label_name {
    type: string
    view_label: "Label"
    label: "Label Name"
    sql: ${TABLE}.label_name;;
  }

  dimension: contract_end_date {
    type: date
    view_label: "Label Contract"
    label: "Contract End Date"
    description: "End Date of current active contract"
    sql: ${TABLE}.contract_end_date;;
  }

  dimension: closer {
    type: string
    view_label: "Label Contract"
    label: "Closer"
    description: "Closer of current active contract"
    sql: ${TABLE}.closer ;;
  }

  dimension: payout_currency_code {
    type: string
    view_label: "Label Contract"
    label: "Payout Currency"
    description: "Payout currency as described in current active contract"
    sql: ${TABLE}.payout_currency_code ;;
  }

  measure: net_rev_last_12_months_usd {
    type: sum
    view_label: "Accounting"
    label: "Net Revenue USD (Last 12 Activity Months)"
    sql: ${TABLE}.net_rev_last_12_months_usd;;
    value_format: "$0.00"
  }

  measure: net_rev_last_12_to_24_months_usd {
    type: sum
    view_label: "Accounting"
    label: "Net Revenue USD (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.net_rev_last_12_to_24_months_usd;;
    value_format: "$0.00"
  }

  measure: net_rev_yoy_change_usd {
    type: sum
    view_label: "Accounting"
    label: "% YoY Change in Net Revenue USD"
    sql: (${TABLE}.net_rev_yoy_change_usd * 100);;
    value_format: "0\%"
  }

  measure: units_last_12_months {
    type: sum
    view_label: "Accounting"
    label: "Units (Last 12 Activity Months)"
    sql: ${TABLE}.units_last_12_months;;
    value_format: "0"
  }

  measure: units_last_12_to_24_months {
    type: sum
    view_label: "Accounting"
    label: "Units (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.units_last_12_to_24_months;;
    value_format: "0"
  }

  measure: units_yoy_change {
    type:  sum
    view_label: "Accounting"
    label: "% YoY Change in Units"
    sql: (${TABLE}.units_yoy_change * 100);;
    value_format: "0\%"
  }

  measure: spotify_units_last_12_months {
    type: sum
    view_label: "Accounting"
    label: "Spotify Units (Last 12 Activity Months)"
    sql: ${TABLE}.spotify_units_last_12_months;;
      value_format: "0"
  }

  measure: spotify_units_last_12_to_24_months {
    type: sum
    view_label: "Accounting"
    label: "Spotify Units (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.spotify_units_last_12_to_24_months;;
      value_format: "0"
  }

  measure: spotify_units_yoy_change {
    type:  sum
    view_label: "Accounting"
    label: "% YoY Change in Spotify Units"
    sql: (${TABLE}.spotify_units_yoy_change * 100);;
      value_format: "0\%"
  }

  measure: apple_units_last_12_months {
    type: sum
    view_label: "Accounting"
    label: "Apple Units (Last 12 Activity Months)"
    sql: ${TABLE}.apple_units_last_12_months;;
      value_format: "0"
  }

  measure: apple_units_last_12_to_24_months {
    type: sum
    view_label: "Accounting"
    label: "Apple Units (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.apple_units_last_12_to_24_months;;
      value_format: "0"
  }

  measure: apple_units_yoy_change {
    type:  sum
    view_label: "Accounting"
    label: "% YoY Change in Apple Units"
    sql: (${TABLE}.apple_units_yoy_change * 100);;
      value_format: "0\%"
  }

  measure: amazon_units_last_12_months {
    type: sum
    view_label: "Accounting"
    label: "Amazon Units (Last 12 Activity Months)"
    sql: ${TABLE}.amazon_units_last_12_months;;
      value_format: "0"
  }

  measure: amazon_units_last_12_to_24_months {
    type: sum
    view_label: "Accounting"
    label: "Amazon Units (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.amazon_units_last_12_to_24_months;;
      value_format: "0"
  }

  measure: amazon_units_yoy_change {
    type:  sum
    view_label: "Accounting"
    label: "% YoY Change in Amazon Units"
    sql: (${TABLE}.amazon_units_yoy_change * 100);;
      value_format: "0\%"
  }

  measure: other_stores_units_last_12_months {
    type: sum
    view_label: "Accounting"
    label: "Other Stores Units (Last 12 Activity Months)"
    sql: ${TABLE}.other_stores_units_last_12_months;;
      value_format: "0"
  }

  measure: other_stores_units_last_12_to_24_months {
    type: sum
    view_label: "Accounting"
    label: "Other Stores Units (Last 12 - 24 Activity Months)"
    sql: ${TABLE}.other_stores_units_last_12_to_24_months;;
      value_format: "0"
  }

  measure: other_stores_units_yoy_change {
    type:  sum
    view_label: "Accounting"
    label: "% YoY Change in Other Stores Units"
    sql: (${TABLE}.other_stores_units_yoy_change * 100);;
      value_format: "0\%"
  }

  dimension: primary_key {
    primary_key: yes
    hidden: yes
    type: string
    sql: CONCAT(
        CAST(${label_id} AS STRING)
      ) ;;
  }

}