view: int_dbt_prod_lmcp_top_overall_tracks { sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_OVERALL_TRACKS";; dimension_group: Activity_date_week{ label:"Activity" type: time sql:${TABLE}.Activity_date_week;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } dimension: Quarterback_label_manager{ label:"Quarterback Label Manager" type: string sql:${TABLE}.Quarterback_label_manager;; } dimension: Label_manager{ label:"Label Manager" type: string sql:${TABLE}.Label_manager;; } dimension: Owner_name{ label:"Owner Name" type: string sql:${TABLE}.Owner_name;; } dimension: Labelid{ label:"Label ID" type: number sql:${TABLE}.Labelid;; } dimension: Label_name{ label:"Label Name" type: string sql:${TABLE}.Label_name;; } dimension: Subaccountid{ label:"Subaccount ID" type: number sql:${TABLE}.Subaccountid;; } dimension: Artist_info_name{ label:"Artist Name" type: string sql:${TABLE}.Artist_info_name;; } dimension: Track_name{ label:"Track Name" type: string sql:${TABLE}.Track_name;; } dimension: Isrc{ label:"ISRC" type: string sql:${TABLE}.Isrc;; } dimension_group: Release_date{ label:"Release Date" type: time sql:${TABLE}.Release_date;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } measure: Streams{ label:"Streams" type: sum sql:${TABLE}.Streams;; } }