Clients

view: clients {
  sql_table_name: accounts ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: storage_exceeded {
    type: number
    sql: ${TABLE}.storage_exceeded ;;
  }

  dimension: storage_used {
    type: number
    sql: ${TABLE}.storage_used ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

- view: clients
  sql_table_name: accounts
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: advert_list_id
    type: int
    sql: ${TABLE}.advert_list_id
  - dimension: bank_recipient_id
    sql: ${TABLE}.bank_recipient_id
  - dimension: client_name
    sql: ${TABLE}.client_name
  - dimension: disabled_reason
    sql: ${TABLE}.disabled_reason
  - dimension: display_settings
    sql: ${TABLE}.display_settings
  - dimension: encrypted_tax_id
    sql: ${TABLE}.encrypted_tax_id
  - dimension: encrypted_tax_id_iv
    sql: ${TABLE}.encrypted_tax_id_iv
  - dimension: encrypted_tax_id_salt
    sql: ${TABLE}.encrypted_tax_id_salt
  - dimension: escrow_days
    type: int
    sql: ${TABLE}.escrow_days
  - dimension: full_legal_name
    sql: ${TABLE}.full_legal_name
  - dimension: header_bg_content_type
    sql: ${TABLE}.header_bg_content_type
  - dimension: header_bg_file_name
    sql: ${TABLE}.header_bg_file_name
  - dimension: header_bg_file_size
    type: int
    sql: ${TABLE}.header_bg_file_size
  - dimension: json_config
    sql: ${TABLE}.json_config
  - dimension: logo_content_type
    sql: ${TABLE}.logo_content_type
  - dimension: logo_file_name
    sql: ${TABLE}.logo_file_name
  - dimension: logo_file_size
    type: int
    sql: ${TABLE}.logo_file_size
  - dimension: logo_id
    type: int
    sql: ${TABLE}.logo_id
  - dimension: membership_level
    sql: ${TABLE}.membership_level
  - dimension: membership_plan_id
    type: int
    sql: ${TABLE}.membership_plan_id
  - dimension: agreement_tnc_url
    sql: ${TABLE}.agreement_tnc_url
  - dimension: name
    sql: ${TABLE}.name
  - dimension: parent_id
    type: int
    sql: ${TABLE}.parent_id
  - dimension: payment_threshold
    type: int
    sql: ${TABLE}.payment_threshold
  - dimension: plan_ids
    sql: ${TABLE}.plan_ids
  - dimension: platform_id
    type: int
    sql: ${TABLE}.platform_id
  - dimension: settings
    sql: ${TABLE}.settings
  - dimension: storage_exceeded
    type: number
    sql: ${TABLE}.storage_exceeded
  - dimension: storage_used
    type: number
    sql: ${TABLE}.storage_used
  - dimension: stripe_access_token
    sql: ${TABLE}.stripe_access_token
  - dimension: stripe_publishable_key
    sql: ${TABLE}.stripe_publishable_key
  - dimension: stripe_user_id
    sql: ${TABLE}.stripe_user_id
  - dimension: tax_id_last4
    type: int
    sql: ${TABLE}.tax_id_last4
  - dimension: user_id
    type: int
    hidden: true
    sql: ${TABLE}.user_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: date_terms_accepted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_terms_accepted
  - dimension_group: header_bg_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.header_bg_updated_at
  - dimension_group: logo_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.logo_updated_at
  - dimension_group: agreement_tnc_dt
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.agreement_tnc_dt
  - dimension_group: next_settlement
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.next_settlement_date
  - dimension_group: settlement
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.settlement_date
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*