view: dt_label_manager_insights_temp {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_LABEL_MANAGER_INSIGHTS_TEMP ;;

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

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

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

  dimension: gross_usd_2018 {
    type: number
    sql: ${TABLE}.gross_usd_2018 ;;
    value_format: "$#,##0.00"
  }

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

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

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

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

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

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

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

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

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

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

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

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