Users

view: users {
  sql_table_name: store_users ;;

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

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

  dimension: preferred_currency {
    sql: ${TABLE}.preferred_currency ;;
  }

  dimension: sign_in_count {
    type: int
    sql: ${TABLE}.sign_in_count ;;
  }

  dimension: subscribed {
    type: yesno
    sql: ${TABLE}.subscribed ;;
  }

  dimension: bill_address_id {
    type: int
    hidden: yes
    sql: ${TABLE}.bill_address_id ;;
  }

  dimension: current_sign_in_ip {
    hidden: yes
    sql: ${TABLE}.current_sign_in_ip ;;
  }

  dimension: failed_attempts {
    type: int
    hidden: yes
    sql: ${TABLE}.failed_attempts ;;
  }

  dimension: last_sign_in_ip {
    hidden: yes
    sql: ${TABLE}.last_sign_in_ip ;;
  }

  dimension: login {
    hidden: yes
    sql: ${TABLE}.login ;;
  }

  dimension: ship_address_id {
    type: int
    hidden: yes
    sql: ${TABLE}.ship_address_id ;;
  }

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

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

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

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

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

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

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

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

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

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

- view: users
  sql_table_name: store_users
  fields:
  - dimension: id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.id
  - dimension: email
    sql: ${TABLE}.email
  - dimension: preferred_currency
    sql: ${TABLE}.preferred_currency
  - dimension: sign_in_count
    type: int
    sql: ${TABLE}.sign_in_count
  - dimension: subscribed
    type: yesno
    sql: ${TABLE}.subscribed
  - dimension: bill_address_id
    type: int
    hidden: true
    sql: ${TABLE}.bill_address_id
  - dimension: current_sign_in_ip
    hidden: true
    sql: ${TABLE}.current_sign_in_ip
  - dimension: failed_attempts
    type: int
    hidden: true
    sql: ${TABLE}.failed_attempts
  - dimension: last_sign_in_ip
    hidden: true
    sql: ${TABLE}.last_sign_in_ip
  - dimension: login
    hidden: true
    sql: ${TABLE}.login
  - dimension: ship_address_id
    type: int
    hidden: true
    sql: ${TABLE}.ship_address_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.created_at
  - dimension_group: last_sign_in
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.last_sign_in_at
  - dimension_group: confirmation_sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.confirmation_sent_at
  - dimension_group: confirmed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.confirmed_at
  - dimension_group: current_sign_in
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.current_sign_in_at
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.deleted_at
  - dimension_group: last_request
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.last_request_at
  - dimension_group: locked
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.locked_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail