Stats User Sessions

view: stats_user_sessions {
  sql_table_name: postgres_public.stats_user_sessions ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count_distinct_users {
    type: count_distinct
    drill_fields: [detail*]
    sql: ${user_id} ;;
  }
}

- view: stats_user_sessions
  sql_table_name: postgres_public.stats_user_sessions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: partner_id
    type: int
    sql: ${TABLE}.partner_id
  - dimension: is_enterprise
    type: yesno
    sql: ${TABLE}.is_enterprise
  - dimension: paying
    type: yesno
    sql: ${TABLE}.paying
  - dimension: product
    type: int
    sql: ${TABLE}.product
  - dimension: remote_ip
    sql: ${TABLE}.remote_ip
  - dimension: session_length
    type: int
    sql: ${TABLE}.session_length
  - dimension: team_id
    type: int
    sql: ${TABLE}.team_id
  - dimension: user_agent
    sql: ${TABLE}.user_agent
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: ended
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.ended_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: count_distinct_users
    type: count_distinct
    drill_fields:
    - detail*
    sql: ${user_id}