film.view.lkml

view: film {
  sql_table_name: leon_thesis_data.film ;;

  dimension: film_id {
    primary_key: yes
    type: number
    sql: ${TABLE}.film_id ;;
    drill_fields: [title]
  }

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

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

  dimension: language_id {
    type: number
    # hidden: yes
    sql: ${TABLE}.language_id ;;
  }

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

  dimension: length {
    type: number
    value_format: "0 \" Minutes\""
    sql: ${TABLE}.length ;;
  }

  dimension: rating {
    type: string
    sql: CAST(${TABLE}.rating as string) ;;
  }

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

  dimension: rental_duration {
    type: number
    value_format: "0 \" Days\""
    sql: ${TABLE}.rental_duration ;;
  }

  dimension: rental_rate {
    type: number
    value_format: "$0.00"
    sql: ${TABLE}.rental_rate ;;
  }

  dimension: replacement_cost {
    type: number
    value_format: "$0.00"
    sql: ${TABLE}.replacement_cost ;;
  }

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

  dimension: title {
    type: string
    sql: ${TABLE}.title ;;
    link: {
      label: "Movie Facts"
      url: "/dashboards/242?Title={{ value }}"
      icon_url: "https://looker.com/favicon.ico"
    }
  }

parameter: title_filter {
  type: string
  hidden: yes
}

dimension: title_filter_dimension{
  type: string
  sql:  { parameter title_filter } ;;
}
  measure: count {
    type: count
    drill_fields: [detail*]
  }

  # ----- Sets of fields for drilling ------
  set: detail {
    fields: [
      title_filter,
      film_id,
      language.name,
      language.language_id,
      film_actor.count,
      film_category.count,
      inventory.count,
      title,
      special_features,
      replacement_cost,
      rental_rate,
      rental_duration,
      release_year,
      rating,
      length,
      language_id,
      fulltext,
      description,
      film_id
    ]
  }
}