Person

view: person {
  sql_table_name: person ;;

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

  dimension: history {
    hidden: yes
    sql: ${TABLE}.id ;;
  }

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

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

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

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

  dimension: company_name {
    sql: ${TABLE}.custom_field_10 ;;
  }

  dimension: audience {
    sql: ${TABLE}.custom_field_6 ;;
  }

  dimension: audience_segment {
    sql: ${TABLE}.custom_field_7 ;;
  }

  dimension: industry {
    sql: ${TABLE}.custom_field_8 ;;
  }

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

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

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

  dimension: engagement_time {
    type: int
    sql: datediff('day', ${first_touch_date}, ${last_touch_date}) ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: engagement_score_average {
    type: average
    sql: ${engagement_time} ;;
  }

  measure: engagement_score_total {
    type: sum
    sql: ${engagement_time} ;;
  }

  measure: engagement_time_average {
    type: average
    sql: ${engagement_time} ;;
  }

  measure: engagement_time_total {
    type: sum
    sql: ${engagement_time} ;;
  }

  measure: count {
    label: "Person Count"
    type: count
    drill_fields: [detail*]
  }
}

- view: person
  sql_table_name: person
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: history
    hidden: true
    sql: ${TABLE}.id
  - dimension: active
    type: yesno
    sql: ${TABLE}.active
  - dimension: anonymous_visitor
    type: yesno
    sql: ${TABLE}.anonymous_visitor
  - dimension: articles_remaining
    type: int
    hidden: true
    sql: ${TABLE}.articles_remaining
  - dimension: as_json
    hidden: true
    sql: ${TABLE}.as_json
  - dimension: company_name
    sql: ${TABLE}.custom_field_10
  - dimension: audience
    sql: ${TABLE}.custom_field_6
  - dimension: audience_segment
    sql: ${TABLE}.custom_field_7
  - dimension: industry
    sql: ${TABLE}.custom_field_8
  - dimension: customer_id
    type: int
    sql: ${TABLE}.customer_id
  - dimension: do_not_track
    type: yesno
    sql: ${TABLE}.do_not_track
  - dimension: engagement_score
    type: int
    sql: ${TABLE}.engagement_score
  - dimension: engagement_time
    type: int
    sql: datediff('day', ${first_touch_date}, ${last_touch_date})
  - dimension: external_score
    type: int
    sql: ${TABLE}.external_score
  - dimension: first_time_visitor
    type: yesno
    sql: ${TABLE}.first_time_visitor
  - dimension: identifiers_json
    hidden: true
    sql: ${TABLE}.identifiers_json
  - dimension: last_subscription_plan
    sql: ${TABLE}.last_subscription_plan
  - dimension: persona
    sql: ${TABLE}.persona
  - dimension: primary_identifier
    sql: ${TABLE}.primary_identifier
  - dimension: primary_identifier_type_id
    type: int
    hidden: true
    sql: ${TABLE}.primary_identifier_type_id
  - dimension: subscriber_status
    hidden: true
    sql: ${TABLE}.subscriber_status
  - dimension: subscription_plan
    hidden: true
    sql: ${TABLE}.subscription_plan
  - dimension_group: first_touch
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.first_touch
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_modified_date
  - dimension_group: last_touch
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_touch
  - dimension_group: subscription_end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.subscription_end_date
  - dimension_group: subscription_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.subscription_start_date
  - measure: engagement_score_average
    type: average
    sql: ${engagement_time}
  - measure: engagement_score_total
    type: sum
    sql: ${engagement_time}
  - measure: engagement_time_average
    type: average
    sql: ${engagement_time}
  - measure: engagement_time_total
    type: sum
    sql: ${engagement_time}
  - measure: count
    type: count
    label: Person Count
    drill_fields:
    - detail*