Profile Metadata

view: profile_metadata {
  sql_table_name: profile_metadata ;;

  dimension: application_state {
  }

  dimension: deliveries_program {
    type: yesno
  }

  dimension: email {
  }

  dimension: first_name {
  }

  dimension: flow {
  }

  dimension: geography_id {
    type: int
  }

  dimension: id {
    type: int
  }

  dimension: last_name {
  }

  dimension: profile_flag_count {
    type: int
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension_group: finished {
    type: time
    timeframes: [yesno, time, date, week, month, year]
    sql: (SELECT MIN(te.created_at)
FROM timeline_events te
WHERE te.event_type='user_runneryes'
  AND te.subject_id=${TABLE}.id) ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }

  measure: bg_check_count {
    type: count_distinct
    filters: [completed_background: "True"]
    sql: ${id} ;;
  }

  measure: finished_count {
    type: count_distinct
    filters: [finished: "True"]
    sql: ${id} ;;
  }
}

- view: profile_metadata
  sql_table_name: profile_metadata
  fields:
  - dimension: application_state
  - dimension: deliveries_program
    type: yesno
  - dimension: email
  - dimension: first_name
  - dimension: flow
  - dimension: geography_id
    type: int
  - dimension: id
    type: int
  - dimension: last_name
  - dimension: profile_flag_count
    type: int
  - dimension_group: application_state_changed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.application_state_changed_at
  - dimension_group: bgcheck_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.bgcheck_state_at
  - dimension_group: bgfailed_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.bgfailed_state_at
  - dimension_group: bid
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.bid_at
  - dimension_group: completed_avatar
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_avatar_at
  - dimension_group: completed_background
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_background_at
  - dimension_group: completed_bio
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_bio_at
  - dimension_group: completed_social_proof
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_social_proof_at
  - dimension_group: completed_traits
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_traits_at
  - dimension_group: completed_video
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_video_at
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: denied_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.denied_state_at
  - dimension_group: facebook_connect
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.facebook_connect_at
  - dimension_group: linkedin_connect
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.linkedin_connect_at
  - dimension_group: outside_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.outside_state_at
  - dimension_group: probation_bgcheck_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.probation_bgcheck_state_at
  - dimension_group: probation_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.probation_state_at
  - dimension_group: published
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.published_at
  - dimension_group: review_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.review_state_at
  - dimension_group: worker_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.runner_state_at
  - dimension_group: started_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.started_state_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - dimension_group: young_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.young_state_at
  - dimension_group: finished
    type: time
    timeframes:
    - yesno
    - time
    - date
    - week
    - month
    - year
    sql: (SELECT MIN(te.created_at)
FROM timeline_events te
WHERE te.event_type='user_runneryes'
  AND te.subject_id=${TABLE}.id)
  - measure: count
    type: count_distinct
    sql: ${id}
  - measure: bg_check_count
    type: count_distinct
    filters:
    - completed_background: True
    sql: ${id}
  - measure: finished_count
    type: count_distinct
    filters:
    - finished: True
    sql: ${id}