view: int_dbt_prod_project_moments_track_groupings_info {
  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: "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/{{moments_track_name_isrc_list.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: 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: 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: 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 ;;
  }

}