# Auto-generated via Rick's RScript on Tue Feb 02  8:26 PM Eastern
view: bi_track_view {
  sql_table_name: prod.som_livre.track_with_upc_view ;;
  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   START Manually Added   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  ##
  ##
  ##                           Put Any Manual Changes Here
  ##
  ##
  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    END  Manually Added   ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start (blank) View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  measure: number_of_rows {
    view_label: ""
    label: "Number of Rows"
    description: "row count for group based on table bi.track_with_upc_view"
    type: count
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End (blank) View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Bucket View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: music_vs_video_by_tracktype {
    view_label: "Bucket"
    label: "Music vs Video by Tracktype"
    description: ""
    sql: ${TABLE}.music_vs_video_by_tracktype ;;
    type: string
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Bucket View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Label View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: label_id {
    view_label: "Label"
    label: "ID"
    description: ""
    alias: [labelid]
    suggestable: yes
    suggest_explore: bi_label_view
    suggest_dimension: bi_label_view.label_id
    sql: ${TABLE}.labelid ;;
    type:  number
    value_format: "####"
  }

  measure: count_distinct_labels {
    view_label: "Label"
    label: "Number of Labels"
    description: "Unique Label counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.labelid ;;
    type: count_distinct
    value_format: "[>=1000000]#,##0.0,,\" M\"; #,###"
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Label View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Release View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: upc {
    view_label: "Release"
    label: "UPC"
    description: ""
    hidden: no
    suggestable: no
    sql: ${TABLE}.upc ;;
    type:  number
    value_format: "####"
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Release View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Track View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: track_cd_number {
    view_label: "Track"
    label: "CD Number"
    description: "Disc number in a collection. Generally 1 or 2. Do not confuse with Track Number"
    sql: ${TABLE}.track_cd_number ;;
    type:  number
    value_format: "####"
  }

  dimension: track_duration {
    view_label: "Track"
    label: "Duration"
    description: ""
    alias: [track_duration_dimension]
    sql: ${TABLE}.track_duration ;;
    type:  number
    value_format: "####"
    html: {% assign modd = value | modulo:60 | round %}
      {% if modd < 10  %}
        {{ value | divided_by:60.0 | round }}:0{{ modd }}
      {% else %}
        {{ value | divided_by:60.0 | round }}:{{ modd }}
      {% endif %}
      ;;
  }

  dimension: track_id {
    view_label: "Track"
    label: "ID"
    description: ""
    hidden: no
    suggestable: no
    sql: ${TABLE}.trackid ;;
    type:  number
    value_format: "####"
  }

  dimension: track_is_dummy_isrc_for_da {
    view_label: "Track"
    label: "Is Dummy ISRC for DA"
    description: ""
    sql: ${TABLE}.track_is_dummy_isrc_for_da = 1 ;;
    type: yesno
  }

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

  dimension: main_isrc {
    view_label: "Track"
    label: "Main ISRC"
    description: "From Track View"
    suggestable: no
    sql: ${TABLE}.main_isrc ;;
    type: string
  }

  dimension: track_name {
    view_label: "Track"
    label: "Name"
    description: ""
    case_sensitive: no
    suggestable: no
    sql: ${TABLE}.track_name ;;
    type: string
    html: <div style="min-width: 120px;">{{ rendered_value }}</div>
      ;;
  }

  dimension: track_name_short {
    view_label: "Track"
    label: "Name Short"
    hidden: no
    description: ""
    suggestable: no
    sql: ${TABLE}.track_name_short ;;
    type: string
    html: <div style="min-width: 50px;">{{ rendered_value }}</div>
      ;;
  }

  dimension: track_number {
    view_label: "Track"
    label: "Number"
    description: "The track's ordering number on an album"
    sql: ${TABLE}.track_number ;;
    type:  number
    value_format: "####"
  }

  measure: count_distinct_track_uniques {
    view_label: "Track"
    label: "Number of Track Uniques"
    description: "Unique Track Unique counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.track_unique_id ;;
    type: count_distinct
    value_format: "[>=1000000]#,##0.0,,\" M\"; #,###"
  }

  measure: count_distinct_tracks {
    view_label: "Track"
    label: "Number of Tracks"
    description: "Unique Track counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.trackid ;;
    type: count_distinct
    value_format: "[>=1000000]#,##0.0,,\" M\"; #,###"
  }

  measure: track_duration_sum {
    view_label: "Track"
    label: "Sum of Duration"
    description: "Aggregated Total of Duration"
    sql: ${TABLE}.track_duration ;;
    type: sum
    value_format: "####"
  }

  dimension: track_unique_id {
    view_label: "Track"
    label: "Unique ID"
    description: ""
    sql: ${TABLE}.track_unique_id ;;
    type: string
    primary_key: yes
  }

  dimension: track_version {
    view_label: "Track"
    label: "Version"
    description: ""
    sql: ${TABLE}.track_version ;;
    type: string
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Track View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##


  set: bi_track_view.all_fields {
    fields: [
      bi_track_view.music_vs_video_by_tracktype,
      bi_track_view.label_id,
      bi_track_view.count_distinct_labels,
      bi_track_view.upc,
      bi_track_view.track_cd_number,
      bi_track_view.track_duration,
      bi_track_view.track_id,
      bi_track_view.track_is_dummy_isrc_for_da,
      bi_track_view.isrc,
      bi_track_view.main_isrc,
      bi_track_view.track_name,
      bi_track_view.track_name_short,
      bi_track_view.track_number,
      bi_track_view.track_unique_id,
      bi_track_view.track_version,
      bi_track_view.count_distinct_track_uniques,
      bi_track_view.count_distinct_tracks,
      bi_track_view.track_duration_sum
    ]
  }

  set: bi_track_view.main_fields {
    fields: [
      bi_track_view.music_vs_video_by_tracktype,
      bi_track_view.track_cd_number,
      bi_track_view.track_duration,
      bi_track_view.track_id,
      bi_track_view.track_is_dummy_isrc_for_da,
      bi_track_view.main_isrc,
      bi_track_view.track_name,
      bi_track_view.track_name_short,
      bi_track_view.track_number,
      bi_track_view.track_unique_id,
      bi_track_view.track_version,
      bi_track_view.count_distinct_track_uniques,
      bi_track_view.count_distinct_tracks,
      bi_track_view.track_duration_sum
    ]
  }
}