view: LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL{
  sql_table_name:INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL;;


  dimension: Label_id{
    label:"Label ID"
    view_label: "Label"
    type: number
    sql:${TABLE}.Label_id;;
  }
  dimension_group: Accounting_month{
    label:"Accounting Month"
    view_label: "Date"
    type: time
    sql:${TABLE}.Accounting_month;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: Activity_month{
    label:"Activity Month"
    view_label: "Date"
    type: time
    sql:${TABLE}.Activity_month;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: Transaction_country_name{
    label:"Transaction Country Name"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Transaction_country_name;;
    html: <font style="color:#0A3454; font-family:arial;" >{{ value }}</font> ;;
  }
  dimension: Transaction_country_code{
    label:"Transaction Country Code"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Transaction_country_code;;
  }
  dimension: Artist_name{
    label:"Artist Name"
    view_label: "Artist"
    type: string
    sql:${TABLE}.Artist_name;;
  }
  dimension: Upc{
    label:"Upc"
    view_label: "Release"
    type: string
    sql:${TABLE}.Upc;;
  }
  measure: number_of_releases {
    label: "Number of Releases"
    view_label: "Release"
    type: count_distinct
    sql: ${TABLE}.upc ;;
  }

  dimension: Release_name{
    label:"Release Name"
    view_label: "Release"
    type: string
    sql:${TABLE}.Release_name;;
  }
  dimension: Display_configuration{
    label:"Display Configuration"
    view_label: "Release"
    type: string
    sql:${TABLE}.Display_configuration;;
  }
  dimension: Digital_v_physical{
    label:"Digital V Physical"
    view_label: "Release"
    type: string
    sql:${TABLE}.Digital_v_physical;;
  }
  dimension: Catalog_type{
    label:"Catalog Type"
    view_label: "Release"
    type: string
    sql:${TABLE}.Catalog_type;;
  }
  dimension_group: Release_date{
    label:"Release Date"
    view_label: "Release"
    type: time
    sql:${TABLE}.Release_date;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      date,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension_group: Sale_start_date{
    label:"Sale Start Date"
    view_label: "Release"
    type: time
    sql:${TABLE}.Sale_start_date;;
    timeframes: [year,
      quarter,
      month,
      month_name,
      month_num,
      date,
      fiscal_month_num,
      fiscal_quarter,
      fiscal_quarter_of_year,
      fiscal_year]
  }
  dimension: Transaction_group{
    label:"Transaction Group"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Transaction_group;;
  }
  measure: Units{
    label:"Units"
    view_label: "Units"
    type: sum
    sql:${TABLE}.Units;;
  }
  measure: Gross_revenue_usd{
    label:"Gross Revenue USD"
    view_label: "Revenue"
    type: sum
    sql:${TABLE}.Gross_revenue_usd;;
    value_format: "$#,##0.00"

  }
  measure: Net_revenue_usd{
    label:"Net Revenue USD"
    view_label: "Revenue"
    type: sum
    sql:${TABLE}.Net_revenue_usd;;
    value_format: "$#,##0.00"
  }
  dimension: Payout_currency_name{
    label:"Payout Currency Name"
    view_label: "Revenue"
    type: string
    sql:${TABLE}.Payout_currency_name;;
  }
  dimension: Payout_currency_code{
    label:"Payout Currency Code"
    view_label: "Revenue"
    type: string
    sql:${TABLE}.Payout_currency_code;;
  }
  measure: Gross_revenue_payout_currency{
    label:"Gross Revenue Payout Currency"
    view_label: "Revenue"
    type: sum
    sql:${TABLE}.Gross_revenue_payout_currency;;
  }
  measure: Net_revenue_payout_currency{
    label:"Net Revenue Payout Currency"
    view_label: "Revenue"
    type: sum
    sql:${TABLE}.Net_revenue_payout_currency;;
  }
  }