Accounts Users

view: accounts_users {
  sql_table_name: accounts_data.users ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: creation {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.creation_date ;;
  }

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

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

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

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

  dimension_group: migrated {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.migrated_at ;;
  }

  dimension_group: photo_updated {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.photo_updated_at ;;
  }

  dimension_group: remember_created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.remember_created_at ;;
  }

  dimension_group: reset_password_sent {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.reset_password_sent_at ;;
  }

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

  measure: count {
    type: count
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    drill_fields: [detail*]
  }

  measure: cumulative_total {
    description: "running total of users created"
    type: running_total
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    sql: ${count} ;;
  }
}

- view: accounts_users
  sql_table_name: accounts_data.users
  fields:
  - dimension: referring_user_id
    type: int
    primary_key: true
    sql: ${TABLE}.referring_user_id
  - dimension: age
    type: int
    sql: ${TABLE}.age
  - dimension: authentication_token
    sql: ${TABLE}.authentication_token
  - dimension: city
    sql: ${TABLE}.city
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: current_sign_in_ip
    sql: ${TABLE}.current_sign_in_ip
  - dimension: email
    sql: ${TABLE}.email
  - dimension: encrypted_password
    sql: ${TABLE}.encrypted_password
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: notification_emails
    type: yesno
    sql: ${TABLE}.notification_emails
  - dimension: grades
    sql: ${TABLE}.grades
  - dimension: group_id
    type: int
    sql: ${TABLE}.group_id
  - dimension: has_loggedin
    type: yesno
    sql: ${TABLE}.has_loggedin
  - dimension: teacher_emails
    type: yesno
    sql: ${TABLE}.teacher_emails
  - dimension: id
    type: int
    sql: ${TABLE}.id
  - dimension: introduced_by
    sql: ${TABLE}.introduced_by
  - dimension: is_bot
    type: yesno
    sql: ${TABLE}.is_bot
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: last_sign_in_ip
    sql: ${TABLE}.last_sign_in_ip
  - dimension: migrated_to
    sql: ${TABLE}.migrated_to
  - dimension: mixpanel_distinct_id
    sql: ${TABLE}.mixpanel_distinct_id
  - dimension: multiple_classes
    type: yesno
    sql: ${TABLE}.multiple_classes
  - dimension: newsletter_subscriber
    type: yesno
    sql: ${TABLE}.newsletter_subscriber
  - dimension: password
    sql: ${TABLE}.password
  - dimension: phone
    sql: ${TABLE}.phone
  - dimension: photo_content_type
    sql: ${TABLE}.photo_content_type
  - dimension: photo_file_name
    sql: ${TABLE}.photo_file_name
  - dimension: photo_file_size
    type: int
    sql: ${TABLE}.photo_file_size
  - dimension: ref_id
    sql: ${TABLE}.ref_id
  - dimension: reset_password_token
    sql: ${TABLE}.reset_password_token
  - dimension: school_id
    type: int
    sql: ${TABLE}.school_id
  - dimension: sign_in_count
    type: int
    sql: ${TABLE}.sign_in_count
  - dimension: state_id
    type: int
    sql: ${TABLE}.state_id
  - dimension: status
    sql: ${TABLE}.status
  - dimension: students
    type: int
    sql: ${TABLE}.students
  - dimension: temp_group_id
    type: int
    sql: ${TABLE}.temp_group_id
  - dimension: temp_site_id
    type: int
    sql: ${TABLE}.temp_site_id
  - dimension: temp_state_id
    type: int
    sql: ${TABLE}.temp_state_id
  - dimension: twitter_id
    sql: ${TABLE}.twitter_id
  - dimension: update_info_token
    sql: ${TABLE}.update_info_token
  - dimension: user_type_id
    type: int
    sql: ${TABLE}.user_type_id
  - dimension: validated
    type: yesno
    sql: ${TABLE}.validated
  - dimension: zip_code
    type: zipcode
    sql: ${TABLE}.zip_code
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - year
    - month_num
    sql: ${TABLE}.created_at
  - dimension_group: creation
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.creation_date
  - dimension_group: current_sign_in
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.current_sign_in_at
  - dimension_group: date_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_updated
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.deleted_at
  - dimension_group: last_sign_in
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_sign_in_at
  - dimension_group: migrated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.migrated_at
  - dimension_group: photo_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.photo_updated_at
  - dimension_group: remember_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.remember_created_at
  - dimension_group: reset_password_sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.reset_password_sent_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    drill_fields:
    - detail*
  - measure: cumulative_total
    type: running_total
    description: running total of users created
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    sql: ${count}