Users

view: users {
  sql_table_name: GENERIC_USERS ;;

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

  dimension: age {
    type: number
  }

  dimension: age_tier {
    type: tier
    sql: ${age} ;;
  }

  dimension: city {
  }

  dimension: country {
  }

  dimension: email {
  }

  dimension: gender {
  }

  dimension: name {
    sql: CONCAT(CONCAT(${TABLE}.first_name,' '), ${TABLE}.last_name) ;;
  }

  dimension: history {
    sql: ${TABLE}.id ;;
  }

  dimension: state {
  }

  dimension: zip {
    type: zipcode
    hidden: yes
  }

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

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

  measure: average_age {
    type: average
    sql: ${age} ;;
  }

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

  measure: count_percent_of_total {
    label: "Count (Percent of Total)"
    type: percent_of_total
    drill_fields: [detail*]
    sql: ${count} ;;
  }
}

- view: users
  sql_table_name: GENERIC_USERS
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: age
    type: number
  - dimension: age_tier
    type: tier
    sql: ${age}
  - dimension: city
  - dimension: country
  - dimension: email
  - dimension: gender
  - dimension: name
    sql: CONCAT(CONCAT(${TABLE}.first_name,' '), ${TABLE}.last_name)
  - dimension: history
    sql: ${TABLE}.id
  - dimension: state
  - dimension: zip
    type: zipcode
    hidden: true
  - dimension: zipcode
    type: zipcode
    sql: ${zip}
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.created_at
  - measure: average_age
    type: average
    sql: ${age}
  - measure: count
    type: count
    drill_fields:
    - detail
  - measure: count_percent_of_total
    type: percent_of_total
    label: Count (Percent of Total)
    drill_fields:
    - detail*
    sql: ${count}