view: int_dbt_prod_weekly_trending_tracks_spotify_continent {
  sql_table_name: INTELLIGENCE.DBT_PROD.WEEKLY_TRENDING_TRACKS_SPOTIFY_CONTINENT_LEVEL ;;

  dimension: continent {
    view_label: "Transaction Country"
    type: string
    hidden: no
    sql: ${TABLE}.continent;;
  }

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


  dimension: isrc {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.isrc;;
  }

  dimension: upc {
    view_label: "Metrics"
    type: number
    hidden: yes
    sql: ${TABLE}.upc;;
  }

  dimension: track_name {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.track_name;;


  }

  dimension: artist_name {
    view_label: "Metrics"
    type: string
    hidden: no
    sql: ${TABLE}.artist_name;;
  }


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

  dimension: average_streams {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.avg_streams;;
    value_format: "#,##0"
  }

  dimension: percent_above_average {
    view_label: "Metrics"
    type: number
    hidden: no
    sql: ${TABLE}.percent_above_avg;;
    value_format: "0.00\%"
  }

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

  dimension: fraud_flag {
    view_label: "Potential Fraud Flag"
    label: "Potential Streaming Fraud"
    type: string
    sql:  ${TABLE}.fraud_flag ;;
    link: {
      label: "Spotify Fraud Detection Deep Dive"
      url:"

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

      https://theorchard.looker.com/dashboards/1906?Label+ID={{int_dbt_prod_weekly_trending_tracks_spotify_continent.labelid._value }}&ISRC={{int_dbt_prod_weekly_trending_tracks_spotify_continent.isrc._value }}

      {% endif %}

      "

    }
  }

  dimension: global_track_streams {
    view_label: "Potential Fraud Flag"
    label: "Global Track Streams"
    type: number
    sql:  ${TABLE}.global_track_streams ;;
  }

  dimension: potential_fraudulent_stream_count_global {
    view_label: "Potential Fraud Flag"
    label: "Potential Fraudulent Streams (Global)"
    type: number
    sql:  ${TABLE}.potential_fraudulent_stream_count_global ;;
  }


  measure: percent_potential_excessive_streams {
    view_label: "Potential Fraud Flag"
    label: "% Potential Excessive Streams"
    sql: ${TABLE}.potential_fraudulent_stream_count_global/${TABLE}.global_track_streams ;;
    type: number
    value_format: "0.00%"
    link: {
      label: "Spotify Fraud Detection Deep Dive"
      url:"

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

      https://theorchard.looker.com/dashboards/1906?Label+ID={{int_dbt_prod_weekly_trending_tracks_spotify_continent.labelid._value }}&ISRC={{int_dbt_prod_weekly_trending_tracks_spotify_continent.isrc._value }}

      {% endif %}

      "
    }
  }






  }