view: int_dev_tallman_moments_performance_groups_v1 {
  sql_table_name: intelligence.dbt_prod_project_moments.project_moments_track_groupings_info ;;

  dimension: top_line_performance_groups {
    view_label: "Performance Group"
    label: "Performance Test Period"
    type: string
    description: "A description of how the tracks were performing for the train dataset. Banded into Steady, Increasing or Decreasing streams based upon the linear gradient of the train dataset"
    sql: ${TABLE}.performance_test_period;;
  }

  dimension: second_line_performance_groups {
    view_label: "Performance Group"
    label: "Slope Test Period"
    type: string
    description: "A description of how the tracks were performing based upon the increase in streams relative to the previous average weekly streams. sum_forecast_errors/weekly_avg_train_dataset_streams"
    sql: ${TABLE}.slope_test_period ;;
  }

  dimension: performance_group_grouped {
    view_label: "Performance Group"
    label: "Performance Group"
    type: string
    sql: concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period) ;;
    link: {
      label: "Moments Performance Groups - Tier 2"
      url:"

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

      https://theorchard.looker.com/dashboards/2733?Performance%20Group={{int_dev_tallman_moments_performance_groups_v1.performance_group_grouped._value}}

      {% endif %}

      "

    }
  }

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

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

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

      https://insights.theorchard.com/song/{{int_dev_tallman_moments_performance_groups_v1.isrc._value}}/?areaView=enabled&period=past6Months&country=GB&store=286

      {% endif %}

      "

    }
    link: {
      label: "Moments Performance Groups - Tier 3"
      url:"

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

      https://theorchard.looker.com/dashboards/2734?ISRC={{int_dev_tallman_moments_performance_groups_v1.isrc._value}}

      {% endif %}

      "

    }

  }


  dimension: isrc_insights_link {
    view_label: "Track"
    label: "ISRC - Insights Link"
    type: string
    sql: ${TABLE}.isrc ;;
    hidden: no
    link: {
      label: "Insights Link"
      url:"

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

      https://insights.theorchard.com/song/{{int_dev_tallman_moments_performance_groups_v1.isrc._value}}/?areaView=enabled

      {% endif %}

      "

    }
  }

  measure: count_tracks {
    view_label: "Track"
    label: "Number of Tracks"
    type: count_distinct
    sql: ${TABLE}.isrc ;;
  }

  dimension: avg_daily_streams {
    view_label: "Performance Metrics"
    label: "Avg Daily Streams (Entire series)"
    type: number
    sql: ${TABLE}.avg_daily_streams ;;
    value_format: "0"
  }

  dimension: sum_forecast_errors {
    view_label: "Performance Metrics"
    label: "Sum Forecast Errors"
    type: number
    sql: ${TABLE}.sum_forecast_errors ;;
    value_format: "0"
  }

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

  dimension: active_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Active Streams (Train Set)"
    type: number
    sql: ${TABLE}.active_streams_train_set ;;
  }

  dimension: active_streams_test_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Active Streams (Test Set)"
    type: number
    sql: ${TABLE}.active_streams_test_set ;;
  }

  dimension: search_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Search Streams (Train Set)"
    type: number
    sql: ${TABLE}.search_streams_train_set ;;
  }

  dimension: search_streams_test_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Search Streams (Test Set)"
    type: number
    sql: ${TABLE}.search_streams_test_set ;;
  }

  dimension: passive_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Passive Streams (Train Set)"
    type: number
    sql: ${TABLE}.passive_streams_train_set ;;
  }

  dimension: passive_streams_test_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Passive Streams (Test Set)"
    type: number
    sql: ${TABLE}.passive_streams_test_set ;;
  }

  dimension: percent_passive {
    view_label: "Performance Metrics - Stream Info"
    label: "% Passive (Test Set)"
    description: "% of total streams that came from passive source from Test Data Set"
    type: number
    sql: ${TABLE}.percent_passive ;;
    value_format: "0\%"
  }

  dimension: collection_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Collection Streams (Train Set)"
    type: number
    sql: ${TABLE}.collection_streams_train_set ;;
  }

  dimension: collection_streams_test_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Collection Streams (Test Set)"
    type: number
    sql: ${TABLE}.collection_streams_test_set ;;
  }

  dimension: total_streams_test_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Total Streams (Test Set)"
    type: number
    sql: ${TABLE}.streams_test_set ;;
  }

  dimension: total_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Total Streams (Train Set)"
    type: number
    sql: ${TABLE}.streams_train_set ;;
  }

  dimension: total_streams_all_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Total Streams (Both Sets)"
    type: number
    sql: ${TABLE}.streams_test_set + ${TABLE}.streams_train_set ;;
  }


  dimension: average_weekly_streams_train_set {
    view_label: "Performance Metrics - Stream Info"
    label: "Average Weekly Streams (Train Set)"
    type: number
    sql: ${TABLE}.average_weekly_streams_train_set ;;
    value_format: "0"
  }

  dimension: percent_growth {
    view_label: "Performance Metrics - Stream Info"
    label: "% Growth"
    description: "% increase in streams when comparing the last week of data with the average weekly streams of the train set"
    type: number
    sql: ${TABLE}.percent_growth ;;
    value_format: "0%"
  }

  dimension: percent_of_average_weekly_prior {
    view_label: "Performance Metrics - Stream Info"
    label: "% of average weekly streams - test set"
    description: "% of the last week of data with the average weekly streams of the train set"
    type: number
    sql: ${TABLE}.percent_of_average_weekly_prior ;;
    value_format: "0%"
  }

  dimension: percent_growth_group {
    view_label: "Performance Metrics - Stream Info"
    label: "% Growth Group"
    type: string
    sql: ${TABLE}.perc_growth_group
      ;;
  }

  dimension: test_set_stream_group {
    view_label: "Performance Metrics - Stream Info"
    label: "Test Set Stream Group"
    type: string
    sql: ${TABLE}.test_set_stream_group
      ;;
  }

  dimension: tiktok_current_week_engagement_score {
    view_label: "TikTok Info"
    label: "Current Week Enagement Score"
    type: number
    sql: zeroifnull(${TABLE}.tiktok_current_week_engagement_score) ;;
    value_format: "0.#"
  }

  dimension: tiktok_trending_info_flag {
    view_label: "TikTok Info"
    label: "TikTok Trending Flag"
    type: string
    sql: ${TABLE}.tiktok_trending_info_flag ;;
  }

  dimension: tiktok_trending_report_date {
    view_label: "TikTok Info"
    label: "Latest Tiktok trending report date"
    type: date
    sql: ${TABLE}.tiktok_trending_report_date ;;
  }

  dimension: tiktok_trending_creations_spike_score {
    view_label: "TikTok Info"
    label: "Trending Report Creations Spike Score"
    type: number
    sql: ${TABLE}.tiktok_trending_creations_spike_score ;;
    value_format: "0.#"
  }

  dimension: tiktok_trending_creations_percent_above_avg {
    view_label: "TikTok Info"
    label: "Trending Report Creations % Above Avg"
    type: number
    sql: ${TABLE}.tiktok_trending_creations_percent_above_avg ;;
    value_format: "0%"
  }

  dimension: tiktok_trending_views_spike_score {
    view_label: "TikTok Info"
    label: "Trending Report Views Spike Score"
    type: number
    sql: ${TABLE}.tiktok_trending_views_spike_score ;;
    value_format: "0.#"
  }

  dimension: tiktok_trending_views_percent_above_avg {
    view_label: "TikTok Info"
    label: "Trending Report Views % Above Avg"
    type: number
    sql: ${TABLE}.tiktok_trending_views_percent_above_avg ;;
    value_format: "0%"
  }

  dimension: tiktok_trending_engagement_spike_score {
    view_label: "TikTok Info"
    label: "Trending Report Engagement Spike Score"
    type: number
    sql: ${TABLE}.tiktok_trending_engagement_spike_score ;;
    value_format: "0.#"
  }

  dimension: tiktok_trending_engagement_percent_above_avg {
    view_label: "TikTok Info"
    label: "Trending Report Engagement % Above Avg"
    type: number
    sql: ${TABLE}.tiktok_trending_engagement_percent_above_avg ;;
    value_format: "0%"
  }



  dimension: performance_group_grouped_overall {
    view_label: "Performance Group"
    label: "Performance Group 3 tier"
    type: string
    sql: concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group) ;;
    link: {
      label: "Moments Performance Groups - Tier 2"
      url:"

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

      https://theorchard.looker.com/dashboards/2733?Performance%20Group={{int_dev_tallman_moments_performance_groups_v1.performance_group_grouped_overall._value}}

      {% endif %}

      "

    }
  }

  dimension: performance_group_grouped_four_tier {
    view_label: "Performance Group"
    label: "Performance Group 4 tier"
    type: string
    sql: concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) ;;
    link: {
      label: "Moments Performance Groups - Tier 2"
      url:"

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

      https://theorchard.looker.com/dashboards/2733?Performance%20Group={{int_dev_tallman_moments_performance_groups_v1.performance_group_grouped_four_tier._value}}

      {% endif %}

      "

    }
  }

  dimension: performance_group_grouped_four_tier_formatted {
    view_label: "Performance Group"
    label: "Performance Group 4 tier - formatted"
    type: string
    sql:
    case
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Down Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'significantly_better_than_predicted - slight_down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Significantly Better; Slight Down Trend; > 80% Growth; > 1000 Daily Streams'

      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Down Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'marginally_better_than_predicted - slight_down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'Slightly Better; Slight Down Trend; > 80% Growth; > 1000 Daily Streams'

      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_up_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Slight Up Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_up_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Slight Up Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_up_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Slight Up Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_up_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Slight Up Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Down Trend; > 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_down_trend - less than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Slight Down Trend; < 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_down_trend - less than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Slight Down Trend; < 80% Growth; > 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_down_trend - greater than 80 percent Growth - less than 1000 Daily Stream Test Set' then 'As Predicted; Slight Down Trend; > 80% Growth; < 1000 Daily Streams'
      when concat(${TABLE}.performance_test_period, ' - ', ${TABLE}.slope_test_period, ' - ', ${TABLE}.perc_growth_group, ' - ', ${TABLE}.test_set_stream_group) = 'as_predicted - slight_down_trend - greater than 80 percent Growth - greater than 1000 Daily Stream Test Set' then 'As Predicted; Slight Down Trend; > 80% Growth; > 1000 Daily Streams'
      else null
      end

      ;;
    link: {
      label: "Moments Performance Groups - Tier 2"
      url:"

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

      https://theorchard.looker.com/dashboards/2733?Performance%20Group={{int_dev_tallman_moments_performance_groups_v1.performance_group_grouped_four_tier._value}}

      {% endif %}

      "

    }
  }

  dimension: format {
    type: string
    sql: ${TABLE}.format ;;
  }
  dimension: genreid {
    type: number
    value_format_name: id
    sql: ${TABLE}.genreid ;;
  }
  dimension: new_release {
    type: string
    sql: ${TABLE}.NEW_RELEASE ;;
  }

  dimension_group: releasedate {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}.RELEASEDATE ;;
  }
  dimension: releasename {
    type: string
    sql: ${TABLE}.RELEASENAME ;;
  }

  dimension_group: sale_start {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}.SALE_START_DATE ;;
  }

  dimension: upc {
    type: number
    sql: ${TABLE}.UPC ;;
  }

  dimension: artistid {
    type: number
    value_format_name: id
    sql: ${TABLE}.ARTISTID ;;
  }

  dimension: labelid {
    type: number
    value_format_name: id
    sql: ${TABLE}.LABELID ;;
  }

  dimension_group: process_run_date {
    view_label: "Process Run Info"
    label: "Process Run"
    type: time
    sql: ${TABLE}.process_run_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]
  }


  dimension: current_week_video_views {
    view_label: "TikTok"
    label: "Current Week Video Views"
    type: number
    sql: zeroifnull(${TABLE}.current_week_video_views) ;;
    value_format: "0"
  }

  dimension: last_week_video_views {
    view_label: "TikTok"
    label: "Last Week Video Views"
    type: number
    sql: ${TABLE}.last_week_video_views ;;
    value_format: "0"
  }

  dimension: video_views_wow {
    view_label: "TikTok"
    label: "Video Views WoW Chg (%)"
    type: number
    sql: zeroifnull((${TABLE}.current_week_video_views/nullif(${TABLE}.last_week_video_views,0)-1)) ;;
    value_format: "0%"
  }

  dimension: current_week_creations {
    view_label: "TikTok"
    label: "Current Week Creations"
    type: number
    sql: zeroifnull(${TABLE}.current_week_creations) ;;
    value_format: "0"
  }

  dimension: last_week_creations {
    view_label: "TikTok"
    label: "Last Week Video Creations"
    type: number
    sql: ${TABLE}.last_week_creations ;;
    value_format: "0"
  }

  dimension: creaions_wow {
    view_label: "TikTok"
    label: "Creations WoW Chg (%)"
    type: number
    sql: zeroifnull((${TABLE}.current_week_creations/nullif(${TABLE}.last_week_creations,0)-1)) ;;
    value_format: "0%"
  }

  dimension: current_week_user_count_all {
    view_label: "User Metrics"
    label: "Current Week Listeners (All)"
    type: number
    sql: ${TABLE}.current_week_listener_count_spotify;;
    value_format: "0"
  }

  dimension: past_week_user_count_all {
    view_label: "User Metrics"
    label: "Past Week Listeners (All)"
    type: number
    sql: ${TABLE}.past_week_listener_count_spotify;;
    value_format: "0"
  }

  dimension: current_week_user_count_all_change {
    view_label: "User Metrics"
    label: "Current Week Listeners WoW Chg (All)"
    type: number
    sql: ${TABLE}.wow_change_all_listener_spotify;;
    value_format: "0%"
  }

  dimension: current_week_user_count_search {
    view_label: "User Metrics"
    label: "Current Week Listeners (Search)"
    type: number
    sql: ${TABLE}.current_week_listener_count_search_spotify;;
    value_format: "0"
  }

  dimension: past_week_user_count_search {
    view_label: "User Metrics"
    label: "Past Week Listeners (Search)"
    type: number
    sql: ${TABLE}.past_week_listener_count_search_spotify;;
    value_format: "0"
  }

  dimension: current_week_user_count_search_change {
    view_label: "User Metrics"
    label: "Current Week Listeners WoW Chg (Search)"
    type: number
    sql: ${TABLE}.wow_change_search_listener_spotify;;
    value_format: "0%"
  }

  dimension: average_rate_of_change_current_week_spotify {
    view_label: "User Metrics"
    label: "Average Rate of Change (Current Week; Users)"
    type: number
    sql: ${TABLE}.average_rate_of_change_current_week_spotify;;
    value_format: "0%"
  }

}