view: distribution_format {
  sql_table_name: art_relations.distribution_format ;;

  dimension: distribution_format_id {
    primary_key: yes
    type: number
    sql: ${TABLE}.distribution_format_id ;;
  }

  dimension: distribution_format_media_id {
    type: number
    sql: ${TABLE}.distribution_format_media_id ;;
  }

  dimension: distribution_format_media_name {
    case: {
      when: {
        sql: ${TABLE}.distribution_format_media_id =1;;
        label: "EP"
        }
      when: {
        sql: ${TABLE}.distribution_format_media_id =2;;
        label: "Album"
      }
      when: {
        sql: ${TABLE}.distribution_format_media_id =3;;
        label: "Single"
      }
   }
    type: string
  }

  dimension: context_type {
    type: string
    sql: ${TABLE}.context_type ;;
  }

  dimension: display_flag {
    type: string
    sql: ${TABLE}.display_flag ;;
  }

  measure: count {
    type: count
    drill_fields: [distribution_format_id]
  }

#   # ----- Sets of fields for drilling ------
#   set: detail {
#     fields: [
#       distribution_format_id,
#       name,
#       releases.count,
#       rollbackdig2336musicvideoformat.count,
#       rollbackphys37releases.count,
#       vw_product.count
#     ]
#   }
}