Sales Reps

view: sales_reps {
  sql_table_name: SalesReps ;;

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

  dimension: active {
    sql: ${TABLE}.Active ;;
  }

  dimension: address {
    sql: ${TABLE}.Address ;;
  }

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

  dimension: commission_balance {
    type: number
    sql: ${TABLE}.Commission_Balance ;;
  }

  dimension: commission_percent {
    type: number
    sql: ${TABLE}.Commission_Percent ;;
  }

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

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

  dimension: employee_id {
    sql: ${TABLE}.Employee_Id ;;
  }

  dimension: fax {
    sql: ${TABLE}.Fax ;;
  }

  dimension: manager_user_id {
    sql: ${TABLE}.Manager_User_id ;;
  }

  dimension: name {
    sql: ${TABLE}.Name ;;
  }

  dimension: rep_comparitor {
    description: "Use in conjunction with rep select filter to compare to other sales reps"
    sql: CASE
  WHEN {% condition rep_select %} ${name} {% endcondition %}
    THEN concat('1 - ',  ${name})
  ELSE '2 - Rest of Sales Team'
END ;;
  }

  dimension: ohm_id {
    sql: ${TABLE}.OHM_Id ;;
  }

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

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

  dimension: sugar_id {
    sql: ${TABLE}.Sugar_Id ;;
  }

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

  dimension: vendor_id {
    sql: ${TABLE}.Vendor_Id ;;
  }

  dimension: web_address {
    sql: ${TABLE}.Web_Address ;;
  }

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

- view: sales_reps
  sql_table_name: SalesReps
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: active
    sql: ${TABLE}.Active
  - dimension: address
    sql: ${TABLE}.Address
  - dimension: city
    sql: ${TABLE}.City
  - dimension: commission_balance
    type: number
    sql: ${TABLE}.Commission_Balance
  - dimension: commission_percent
    type: number
    sql: ${TABLE}.Commission_Percent
  - dimension: country_id
    type: int
    sql: ${TABLE}.Country_Id
  - dimension: email
    sql: ${TABLE}.Email
  - dimension: employee_id
    sql: ${TABLE}.Employee_Id
  - dimension: fax
    sql: ${TABLE}.Fax
  - dimension: manager_user_id
    sql: ${TABLE}.Manager_User_id
  - dimension: name
    sql: ${TABLE}.Name
  - dimension: rep_comparitor
    description: Use in conjunction with rep select filter to compare to other sales reps
    sql: CASE
  WHEN {% condition rep_select %} ${name} {% endcondition %}
    THEN concat('1 - ',  ${name})
  ELSE '2 - Rest of Sales Team'
END
  - dimension: ohm_id
    sql: ${TABLE}.OHM_Id
  - dimension: phone
    sql: ${TABLE}.Phone
  - dimension: state_id
    type: int
    sql: ${TABLE}.State_Id
  - dimension: sugar_id
    sql: ${TABLE}.Sugar_Id
  - dimension: type
    type: yesno
    sql: ${TABLE}.Type
  - dimension: vendor_id
    sql: ${TABLE}.Vendor_Id
  - dimension: web_address
    sql: ${TABLE}.Web_Address
  - measure: count
    type: count
    drill_fields:
    - detail*