Accounts Groups

view: accounts_groups {
  sql_table_name: accounts_data.groups ;;

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

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

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

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

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

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

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

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

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

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

  dimension: included_group {
    description: "Is the individual included in reporting"
    type: yesno
    sql: ${reporting_exclude} = 0 or ${reporting_exclude} is null ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

- view: accounts_groups
  sql_table_name: accounts_data.groups
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: contract_exclude
    type: yesno
    sql: ${TABLE}.contract_exclude
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: excluded_from_hijack
    type: yesno
    sql: ${TABLE}.excluded_from_hijack
  - dimension: group_type
    sql: ${TABLE}.group_type
  - dimension: home_reporting
    type: yesno
    sql: ${TABLE}.home_reporting
  - dimension: image
    sql: ${TABLE}.image
  - dimension: lesson_sets_id
    type: int
    sql: ${TABLE}.lesson_sets_id
  - dimension: name
    sql: ${TABLE}.name
  - dimension: reporting_exclude
    type: int
    hidden: true
    sql: ${TABLE}.reporting_exclude
  - dimension: included_group
    type: yesno
    description: Is the individual included in reporting
    sql: ${reporting_exclude} = 0 or ${reporting_exclude} is null
  - dimension: school_district_id
    type: int
    sql: ${TABLE}.school_district_id
  - dimension: school_type_id
    type: int
    sql: ${TABLE}.school_type_id
  - dimension: site_id
    type: int
    sql: ${TABLE}.site_id
  - dimension: state_id
    type: int
    sql: ${TABLE}.state_id
  - dimension: status
    sql: ${TABLE}.status
  - dimension: tagline
    sql: ${TABLE}.tagline
  - dimension: user_count
    type: int
    sql: ${TABLE}.user_count
  - dimension_group: creation
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.creation_date
  - dimension_group: date_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_updated
  - dimension_group: expiration
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.expiration_date
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_date
  - dimension_group: status_change
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.status_change_date
  - measure: count
    type: count
    drill_fields:
    - detail*