view: int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks {
  sql_table_name: INTELLIGENCE.DBT_PROD.ROLLING_WEEKLY_TIKTOK_TRENDING_VIDEO_VIEWS_5_WEEKS ;;

  dimension: labelid {
    view_label: "Label"
    label: "Label ID"
    type: number
    hidden: yes
    sql: ${TABLE}.labelid ;;
  }

  dimension: label_country {
    view_label: "Label"
    label: "Label Country"
    type: string
    sql: ${TABLE}.label_country ;;
  }

  dimension: territory {
    view_label: "Transaction Country"
    label: "Country Code"
    type: string
    sql: ${TABLE}.territory ;;
  }

  dimension: isrc {
    view_label: "Track"
    label: "ISRC"
    type: string
    sql: ${TABLE}.isrc ;;
  }

  dimension: upc {
    view_label: "Release"
    label: "UPC"
    type: number
    sql: ${TABLE}.upc ;;
  }

  dimension: track_name {
    view_label: "Track"
    label: "Track Name"
    type: string
    sql: ${TABLE}.track_name ;;
    link: {
      label: "TikTok Trending - Deep Dive"
      url:"

      {% if _explore._name == 'int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks' %}

      https://theorchard.looker.com/dashboards/2023?Label+ID={{orch_app_ar_vendor.vendor_id._value }}&Transaction+Country={{facts_prod_dim_country.country_name._value }}&ISRC={{int_dbt_prod_rolling_weekly_tiktok_trending_video_views_5_weeks.isrc._value }}&Activity+Date=32+days+ago+for+31+days

      {% endif %}

      "

    }
  }

  dimension: artist_name {
    view_label: "Artist"
    label: "Artist Name"
    type: string
    sql: ${TABLE}.artist_name ;;
  }

  dimension: current_week_creations {
    view_label: "Metrics"
    label: "Weekly Creations"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_creations;;
  }

  dimension: average_creations {
    view_label: "Metrics"
    label: "Average Creations"
    type: number
    hidden: no
    sql: ${TABLE}.avg_creations;;
    value_format: "#,##0"
  }

  dimension: percent_above_average {
    view_label: "Metrics"
    label: "Percent Above Average Creations"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_creations;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation {
    view_label: "Metrics"
    label: "Standard Deviation Creations"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_creations;;
    value_format: "#,##0"
  }

  dimension: spike_score {
    view_label: "Metrics"
    label: "Spike Score Creations"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_creations;;
    value_format: "0.##"
  }

  dimension: current_week_video_views {
    view_label: "Metrics"
    label: "Weekly Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_video_views;;
  }

  dimension: average_video_views {
    view_label: "Metrics"
    label: "Average Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.avg_video_views;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_video_views {
    view_label: "Metrics"
    label: "Percent Above Average Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_video_views;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_video_views {
    view_label: "Metrics"
    label: "Standard Deviation Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_video_views;;
    value_format: "#,##0"
  }

  dimension: spike_score_video_views {
    view_label: "Metrics"
    label: "Spike Score Video Views"
    type: number
    hidden: no
    sql: ${TABLE}.spike_score_video_views;;
    value_format: "0.##"
  }

}