User

view: user {
  sql_table_name: auth_user ;;

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

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

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

  dimension: host_name {
    label: "HOST USER Name"
    sql: ${name} ;;
  }

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

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

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

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

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

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

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

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

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

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

  measure: percent_of_total {
    type: percent_of_total
    sql: ${count} ;;
  }
}

- view: user
  sql_table_name: auth_user
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: email
    sql: ${TABLE}.email
  - dimension: name
    sql: CONCAT(${TABLE}.first_name,' ', ${TABLE}.last_name)
  - dimension: host_name
    label: HOST USER Name
    sql: ${name}
  - dimension: first_name
    sql: ${TABLE}.first_name
  - dimension: is_active
    type: yesno
    sql: ${TABLE}.is_active
  - dimension: is_staff
    type: yesno
    sql: ${TABLE}.is_staff
  - dimension: is_superuser
    type: yesno
    sql: ${TABLE}.is_superuser
  - dimension: last_name
    sql: ${TABLE}.last_name
  - dimension: password
    sql: ${TABLE}.password
  - dimension: username
    sql: ${TABLE}.username
  - dimension_group: date_joined
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_joined
  - dimension_group: last_login
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_login
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: percent_of_total
    type: percent_of_total
    sql: ${count}