view: LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL{
  sql_table_name:INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_NON_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;;
    html: <font style="color:#0A3454; font-family:arial;" >{{ value }}</font> ;;
    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: Country_name{
    label:"Country Name"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Country_name;;
  }
  dimension: Country_code{
    label:"Country Code"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Country_code;;
  }
  dimension: Store_id{
    label:"Store ID"
    view_label: "Store"
    type: number
    sql:${TABLE}.Store_id;;
  }
  dimension: Store_name{
    label:"Store Name"
    view_label: "Store"
    type: string
    sql:${TABLE}.Store_name;;
  }
  dimension: Transaction_group{
    label:"Transaction Group"
    view_label: "Transaction"
    type: string
    sql:${TABLE}.Transaction_group;;
  }
  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;;
  }
  dimension: Payout_currency_id{
    label:"Payout Currency ID"
    view_label: "Revenue"
    type: string
    sql:${TABLE}.Payout_currency_id;;
  }

  measure: Units{
    label:"Units"
    view_label: "Stream"
    type: sum
    sql:${TABLE}.Units;;

  }
  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;;

  }
  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"
  }
  }