view: int_dbt_prod_lmcp_top_playlists_radio { sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_TOP_PLAYLISTS_RADIO";; dimension_group: Download_activity_date_week{ label:"Activity" type: time sql:${TABLE}.Download_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: Label_name{ label:"Label Name" type: string sql:${TABLE}.Label_name;; } dimension: Labelid{ label:"Label ID" type: number sql:${TABLE}.Labelid;; } dimension: Subaccount_name{ label:"Subaccount Name" type: string sql:${TABLE}.Subaccount_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: Releaseid{ label:"Release ID" type: number sql:${TABLE}.Releaseid;; } dimension: Release_name{ label:"Release Name" type: string sql:${TABLE}.Release_name;; } dimension: Track_name{ label:"Track Name" type: string sql:${TABLE}.Track_name;; } dimension: Isrc{ label:"ISRC" type: string sql:${TABLE}.Isrc;; } dimension: Playlistname{ label:"Playlist Name" type: string sql:${TABLE}.Playlistname;; } dimension: Store_name{ label:"Store Name" type: string sql:${TABLE}.Store_name;; } measure: Streams{ label:"Streams" type: sum sql:${TABLE}.Streams;; } }