users.view.lkml

view: users {
  sql_table_name: demo_db.users ;;

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

  dimension: id_string {
    type: string
    sql: CASE WHEN ${id} > 150 THEN CAST(${id} AS CHAR)
              ELSE "< 150"
         END ;;
  }

  dimension: age {
    type: number
    sql: ${TABLE}.age ;;
#     html: <a href="https://localhost:9999/dashboards/2?Untitled%20Filter=otherthing,%22thing,%20you%20see%22">{{ value }}</a> ;;
  }

  dimension: age_tier {
    type: tier
    tiers: [0, 10, 15, 20, 25, 50]
    style: integer
    sql: ${age} ;;
  }

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

  dimension: country {
    type: string
    map_layer_name: countries
    sql: ${TABLE}.country ;;
  }

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

  dimension_group: all_frames {
    type: time
    sql: ${TABLE}.created_at ;;
  }

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

  dimension: first_name {
    type: string
    sql: ${TABLE}.first_name ;;
    html: <a href="{{ value }}">{{ value }}</a> ;;
  }

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

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

  dimension: state {
    type: string
    map_layer_name: us_states
    sql: ${TABLE}.state ;;
  }

  dimension: zip {
    type: zipcode
    sql: ${TABLE}.zip ;;
  }

  dimension: wrong_id_type {
    type: string
    sql: ${TABLE}.id ;;
  }

  measure: count {
    type: count
#     drill_fields: [detail*]
  }

  measure: max_date {
    type: date
    sql: MAX(${created_date}) ;;
#     drill_fields: []
  }

  # ----- Sets of fields for drilling ------
  set: detail {
    fields: [
      id,
      first_name,
      last_name,
      events.count,
      orders.count,
      user_data.count
    ]
  }
}