People

view: people {
  sql_table_name: harvest.people ;;

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

  dimension: cost_rate {
    type: number
    sql: ${TABLE}.cost_rate ;;
  }

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

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

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

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

  dimension: name {
    sql: ${first_name} || ' ' || ${last_name} ;;
  }

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, first_name, last_name]
  }
}

- view: people
  sql_table_name: harvest.people
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: cost_rate
    type: number
    sql: ${TABLE}.cost_rate
  - dimension: default_hourly_rate
    type: int
    sql: ${TABLE}.default_hourly_rate
  - dimension: department
    sql: ${TABLE}.department
  - dimension: email
    sql: ${TABLE}.email
  - dimension: first_name
    hidden: true
    sql: ${TABLE}.first_name
  - dimension: name
    sql: ${first_name} || ' ' || ${last_name}
  - dimension: has_access_to_all_future_projects
    type: yesno
    sql: ${TABLE}.has_access_to_all_future_projects
  - dimension: is_active
    type: yesno
    sql: ${TABLE}.is_active
  - dimension: is_admin
    type: yesno
    sql: ${TABLE}.is_admin
  - dimension: is_contractor
    type: yesno
    sql: ${TABLE}.is_contractor
  - dimension: last_name
    hidden: true
    sql: ${TABLE}.last_name
  - dimension: telephone
    sql: ${TABLE}.telephone
  - dimension: timezone
    sql: ${TABLE}.timezone
  - dimension: wants_newsletter
    type: yesno
    sql: ${TABLE}.wants_newsletter
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - first_name
    - last_name