Brain Break Sessions

view: brain_break_sessions {
  sql_table_name: archive_production.brain_break_sessions ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: students {
    type: int
    sql: CASE
  WHEN ${TABLE}.students > 100 THEN 22
  WHEN ${user_type_id} = 44 or ${user_type_id} = 52 THEN 1
  ELSE ${TABLE}.students
END ;;
  }

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

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

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

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

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

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

  dimension: is_played {
    type: int
    sql: CASE
WHEN (
COALESCE(${vigorous_seconds},0) +
COALESCE(${moderate_seconds},0) +
COALESCE(${calming_seconds}, 0) +
COALESCE(${uncategorized_seconds}, 0)
) > 0
THEN 1 ELSE 0 END ;;
  }

  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: [detail*]
  }

  measure: count_uid {
    label: "User Count"
    description: "count of users"
    type: count_distinct
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    drill_fields: [state_id, count_uid]
    sql: ${uid} ;;
  }

  measure: count_id {
    description: "count of sessions"
    type: count_distinct
    sql: ${id} ;;
  }

  measure: sum_vigorous_min {
    type: sum
    sql: ${vigorous_seconds} / 60 ;;
  }

  measure: sum_calming_min {
    type: sum
    sql: ${calming_seconds} / 60 ;;
  }

  measure: sum_moderate_min {
    type: sum
    sql: ${moderate_seconds} / 60 ;;
  }

  measure: sum_students {
    type: sum
    sql: ${students} ;;
  }

  measure: total_min {
    description: "Student Minutes of Physical Activity"
    type: number
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    sql: (${sum_vigorous_min} + ${sum_calming_min} + ${sum_moderate_min}) * ${sum_students} ;;
  }

  measure: brain_breaks_played {
    type: sum
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    sql: ${is_played} ;;
  }

  measure: verified_kid_count {
    description: "count of verified kids"
    type: count_distinct
    sql: ${resource_id} ;;
  }
}

- view: brain_break_sessions
  sql_table_name: archive_production.brain_break_sessions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: abnormal
    type: yesno
    sql: ${TABLE}.abnormal
  - dimension: brain_break_id
    type: int
    sql: ${TABLE}.brain_break_id
  - dimension: brain_break_type
    sql: ${TABLE}.brain_break_type
  - dimension: calming_seconds
    type: int
    sql: ${TABLE}.calming_seconds
  - dimension: completed
    type: yesno
    sql: ${TABLE}.completed
  - dimension: country_id
    type: int
    sql: ${TABLE}.country_id
  - dimension: deleted_at
    sql: ${TABLE}.deleted_at
  - dimension: group_id
    type: int
    sql: ${TABLE}.group_id
  - dimension: kid_verified
    type: yesno
    sql: ${TABLE}.kid_verified
  - dimension: moderate_seconds
    type: int
    sql: ${TABLE}.moderate_seconds
  - dimension: points_awarded
    type: yesno
    sql: ${TABLE}.points_awarded
  - dimension: resource_id
    type: int
    sql: ${TABLE}.resource_id
  - dimension: resource_type
    sql: ${TABLE}.resource_type
  - dimension: school_id
    type: int
    sql: ${TABLE}.school_id
  - dimension: site_id
    type: int
    sql: ${TABLE}.site_id
  - dimension: state_id
    type: int
    sql: ${TABLE}.state_id
  - dimension: students
    type: int
    sql: CASE
  WHEN ${TABLE}.students > 100 THEN 22
  WHEN ${user_type_id} = 44 or ${user_type_id} = 52 THEN 1
  ELSE ${TABLE}.students
END
  - dimension: uid
    type: int
    sql: ${TABLE}.uid
  - dimension: uncategorized_seconds
    type: int
    sql: ${TABLE}.uncategorized_seconds
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension: user_type_id
    type: int
    sql: ${TABLE}.user_type_id
  - dimension: vigorous_seconds
    type: int
    sql: ${TABLE}.vigorous_seconds
  - dimension: zip_code
    sql: ${TABLE}.zip_code
  - dimension: is_played
    type: int
    sql: CASE
WHEN (
COALESCE(${vigorous_seconds},0) +
COALESCE(${moderate_seconds},0) +
COALESCE(${calming_seconds}, 0) +
COALESCE(${uncategorized_seconds}, 0)
) > 0
THEN 1 ELSE 0 END
  - 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:
    - detail*
  - measure: count_uid
    type: count_distinct
    label: User Count
    description: count of users
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    drill_fields:
    - state_id
    - count_uid
    sql: ${uid}
  - measure: count_id
    type: count_distinct
    description: count of sessions
    sql: ${id}
  - measure: sum_vigorous_min
    type: sum
    sql: ${vigorous_seconds} / 60
  - measure: sum_calming_min
    type: sum
    sql: ${calming_seconds} / 60
  - measure: sum_moderate_min
    type: sum
    sql: ${moderate_seconds} / 60
  - measure: sum_students
    type: sum
    sql: ${students}
  - measure: total_min
    type: number
    description: Student Minutes of Physical Activity
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    sql: (${sum_vigorous_min} + ${sum_calming_min} + ${sum_moderate_min}) * ${sum_students}
  - measure: brain_breaks_played
    type: sum
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    sql: ${is_played}
  - measure: verified_kid_count
    type: count_distinct
    description: count of verified kids
    sql: ${resource_id}