view: orch_app_ar_login_stat {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.login_stat ;;

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

  dimension: impersonated {
    type: number
    sql: ${TABLE}.impersonated ;;
    hidden: yes
  }

  # dimension: ip {
  #   type: string
  #   sql: ${TABLE}.ip ;;
  # }

  dimension_group: login {
    type: time
    timeframes: [time, date, week, month, year]
    sql: ${TABLE}.login_time ;;
    convert_tz: no
  }

  dimension: user_id {
    type: number
    sql: ${TABLE}.user_id ;;
    hidden: yes
  }

  # dimension: user_type {
  #   type: string
  #   sql: ${TABLE}.user_type ;;
  # }

  measure: number_of_logins {
    type: count_distinct
    sql: ${TABLE}.id ;;
    filters: { field: impersonated value: "NULL" }
  }
}