view: int_dbt_prod_tiktok_trending_tracks {
    sql_table_name: INTELLIGENCE.DBT_PROD.TIKTOK_TRENDING_TRACKS ;;

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

    dimension: new_entry_flag {
      view_label: "New Entry"
      label: "New Entry Flag"
      type: string
      sql: ${TABLE}.new_entry_flag ;;
    }

    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_tiktok_trending_tracks' %}

        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_tiktok_trending_tracks.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.##"
    }




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

  dimension: average_comments {
    view_label: "Metrics"
    label: "Average Comments"
    type: number
    hidden: no
    sql: ${TABLE}.avg_comments;;
    value_format: "#,##0"
  }

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

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

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

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

  dimension: average_likes {
    view_label: "Metrics"
    label: "Average Likes"
    type: number
    hidden: no
    sql: ${TABLE}.avg_likes;;
    value_format: "#,##0"
  }

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

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

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

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

  dimension: average_shares {
    view_label: "Metrics"
    label: "Average Shares"
    type: number
    hidden: no
    sql: ${TABLE}.avg_shares;;
    value_format: "#,##0"
  }

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

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

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

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

  dimension: average_favorites {
    view_label: "Metrics"
    label: "Average Favourites"
    type: number
    hidden: no
    sql: ${TABLE}.avg_favorites;;
    value_format: "#,##0"
  }

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

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

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



  dimension: current_week_engagement_score {
    view_label: "Metrics"
    label: "Weekly Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.current_week_engagement_score;;
  }

  dimension: average_engagement_score {
    view_label: "Metrics"
    label: "Average Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.avg_engagement_score;;
    value_format: "#,##0"
  }

  dimension: percent_above_average_engagement_score {
    view_label: "Metrics"
    label: "Percent Above Average Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg_engagement_score;;
    value_format: "0.00\%"
  }

  dimension: standard_deviation_engagement_score {
    view_label: "Metrics"
    label: "Standard Deviation Engagement Score"
    type: number
    hidden: no
    sql: ${TABLE}.standard_deviation_engagement_score;;
    value_format: "#,##0"
  }

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



  }