All Members

view: all_members {
  sql_table_name: warehouse.dim_all_members ;;

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

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

  dimension: cancellation_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.cancellation_date, '') != '' ;;
  }

  dimension: cancellation_week {
    type: date
    sql: to_date(date_sub(${TABLE}.cancellation_date, (dayofweek(${TABLE}.cancellation_date)+5)%7)) ;;
  }

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

  dimension: first_sub_start_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.first_sub_start_time, '') != '' ;;
  }

  dimension: first_sub_start_week {
    type: date
    sql: to_date(date_sub(${TABLE}.first_sub_start_time, (dayofweek(${TABLE}.first_sub_start_time)+5)%7)) ;;
  }

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

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

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

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

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

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

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

  dimension: paying_sub_start_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.paying_sub_start_date, '') != '' ;;
  }

  dimension: paying_sub_start_week {
    type: date
    sql: to_date(date_sub(${TABLE}.paying_sub_start_date, (dayofweek(${TABLE}.paying_sub_start_date)+5)%7)) ;;
  }

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

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

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

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

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

  dimension: sub_end_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.sub_end_time, '') != '' ;;
  }

  dimension: sub_end_week {
    type: date
    sql: to_date(date_sub(${TABLE}.sub_end_time, (dayofweek(${TABLE}.sub_end_time)+5)%7)) ;;
  }

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

  dimension: sub_start_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.sub_start_time, '') != '' ;;
  }

  dimension: sub_start_week {
    type: date
    sql: to_date(date_sub(${TABLE}.sub_start_time, (dayofweek(${TABLE}.sub_start_time)+5)%7)) ;;
  }

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

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

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

  dimension_group: cancellation {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.cancellation_date ;;
  }

  dimension_group: first_sub_start {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.first_sub_start_time ;;
  }

  dimension_group: paying_sub_start {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.paying_sub_start_date ;;
  }

  dimension_group: sub_end {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.sub_end_time ;;
  }

  dimension_group: sub_start {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.sub_start_time ;;
  }

  measure: count {
    type: count
  }
}

- view: all_members
  sql_table_name: warehouse.dim_all_members
  fields:
  - dimension: ds
    sql: ${TABLE}.ds
  - dimension: amount_paid_usd
    type: number
    sql: ${TABLE}.amount_paid_usd
  - dimension: cancellation_yesno
    type: yesno
    sql: COALESCE(${TABLE}.cancellation_date, '') != ''
  - dimension: cancellation_week
    type: date
    sql: to_date(date_sub(${TABLE}.cancellation_date, (dayofweek(${TABLE}.cancellation_date)+5)%7))
  - dimension: country
    sql: ${TABLE}.country
  - dimension: first_sub_start_yesno
    type: yesno
    sql: COALESCE(${TABLE}.first_sub_start_time, '') != ''
  - dimension: first_sub_start_week
    type: date
    sql: to_date(date_sub(${TABLE}.first_sub_start_time, (dayofweek(${TABLE}.first_sub_start_time)+5)%7))
  - dimension: free_trial_duration
    type: number
    sql: ${TABLE}.free_trial_duration
  - dimension: has_ever_paid
    type: int
    sql: ${TABLE}.has_ever_paid
  - dimension: is_in_trial
    type: number
    sql: ${TABLE}.is_in_trial
  - dimension: is_subscriber
    type: number
    sql: ${TABLE}.is_subscriber
  - dimension: num_days_subscribed
    type: number
    sql: ${TABLE}.num_days_subscribed
  - dimension: num_days_subscribed_all_time
    type: number
    sql: ${TABLE}.num_days_subscribed_all_time
  - dimension: num_times_subscribed
    type: number
    sql: ${TABLE}.num_times_subscribed
  - dimension: paying_sub_start_yesno
    type: yesno
    sql: COALESCE(${TABLE}.paying_sub_start_date, '') != ''
  - dimension: paying_sub_start_week
    type: date
    sql: to_date(date_sub(${TABLE}.paying_sub_start_date, (dayofweek(${TABLE}.paying_sub_start_date)+5)%7))
  - dimension: referral_source
    sql: ${TABLE}.referral_source
  - dimension: referral_type
    sql: ${TABLE}.referral_type
  - dimension: signup_doc
    sql: ${TABLE}.signup_doc
  - dimension: signup_page
    sql: ${TABLE}.signup_page
  - dimension: signup_platform
    sql: ${TABLE}.signup_platform
  - dimension: sub_end_yesno
    type: yesno
    sql: COALESCE(${TABLE}.sub_end_time, '') != ''
  - dimension: sub_end_week
    type: date
    sql: to_date(date_sub(${TABLE}.sub_end_time, (dayofweek(${TABLE}.sub_end_time)+5)%7))
  - dimension: sub_plan
    sql: ${TABLE}.sub_plan
  - dimension: sub_start_yesno
    type: yesno
    sql: COALESCE(${TABLE}.sub_start_time, '') != ''
  - dimension: sub_start_week
    type: date
    sql: to_date(date_sub(${TABLE}.sub_start_time, (dayofweek(${TABLE}.sub_start_time)+5)%7))
  - dimension: sub_type
    sql: ${TABLE}.sub_type
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: ds
    type: time
    timeframes:
    - date
    - month
    - year
    sql: ${TABLE}.ds
  - dimension_group: cancellation
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.cancellation_date
  - dimension_group: first_sub_start
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.first_sub_start_time
  - dimension_group: paying_sub_start
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.paying_sub_start_date
  - dimension_group: sub_end
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.sub_end_time
  - dimension_group: sub_start
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.sub_start_time
  - measure: count
    type: count