data.ml
LKML Digital journalism

Plus Members

Plus Members model for digital journalism.

inferred

Blocks

plus_members.view.lkml · 40 lines
inferred 
view: plus_members {
  sql_table_name: companyplus.users_member ;;

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

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

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

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

  dimension: uuid {
    primary_key: yes
    sql: ${TABLE}.uuid ;;
  }

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

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

  measure: count {
    type: count
  }
}
plus_members.view.lookml · 27 lines
source-preserved 
- view: plus_members
  sql_table_name: companyplus.users_member
  fields:
  - dimension: membership_status
    sql: ${TABLE}.membership_status
  - dimension: membership_type
    sql: ${TABLE}.membership_type
  - dimension: paid
    type: yesno
    sql: ${TABLE}.paid
  - dimension: payment_provider
    sql: ${TABLE}.payment_provider
  - dimension: uuid
    primary_key: true
    sql: ${TABLE}.uuid
  - dimension: favorite_author_id
    sql: ${TABLE}.favorite_author_id
  - dimension_group: start
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.start_date
  - measure: count
    type: count

Contents

  • plus_members.view.lkml
  • plus_members.view.lookml