data.ml
LKML Club subscription

Skip Quiz

Skip Quiz model for club subscription.

inferred

Blocks

skip_quiz.view.lkml · 84 lines
inferred 
view: skip_quiz {
  sql_table_name: api.skip_quiz ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [context_library_name]
  }
}
skip_quiz.view.lookml · 55 lines
source-preserved 
- view: skip_quiz
  sql_table_name: api.skip_quiz
  fields:
  - dimension: anonymous_id
    sql: ${TABLE}.anonymous_id
  - dimension: category
    sql: ${TABLE}.category
  - dimension: context_ip
    sql: ${TABLE}.context_ip
  - dimension: context_library_name
    sql: ${TABLE}.context_library_name
  - dimension: context_library_version
    sql: ${TABLE}.context_library_version
  - dimension: context_page_path
    sql: ${TABLE}.context_page_path
  - dimension: context_page_referrer
    sql: ${TABLE}.context_page_referrer
  - dimension: context_page_search
    sql: ${TABLE}.context_page_search
  - dimension: context_page_title
    sql: ${TABLE}.context_page_title
  - dimension: context_page_url
    sql: ${TABLE}.context_page_url
  - dimension: context_user_agent
    sql: ${TABLE}.context_user_agent
  - dimension: event
    sql: ${TABLE}.event
  - dimension: event_id
    sql: ${TABLE}.event_id
  - dimension: event_text
    sql: ${TABLE}.event_text
  - dimension: label
    sql: ${TABLE}.label
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension_group: received
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.received_at
  - dimension_group: sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.sent_at
  - measure: count
    type: count
    drill_fields:
    - context_library_name

Contents

  • skip_quiz.view.lkml
  • skip_quiz.view.lookml