data.ml
LookML Saas usability testing

Subscriptions

Subscriptions model for saas usability testing.

source-preserved

Blocks

subscriptions.view.lkml · 134 lines
inferred 
view: subscriptions {
  sql_table_name: company_orders_production.subscriptions ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
subscriptions.view.lookml · 103 lines
source-preserved 
- view: subscriptions
  sql_table_name: company_orders_production.subscriptions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: account_id
    type: int
    sql: ${TABLE}.account_id
  - dimension: accounting_other
    sql: ${TABLE}.accounting_other
  - dimension: agreed_commitment_months
    type: int
    sql: ${TABLE}.agreed_commitment_months
  - dimension: agreed_total_price
    type: number
    sql: ${TABLE}.agreed_total_price
  - dimension: agreement_id
    type: int
    sql: ${TABLE}.agreement_id
  - dimension: cc_billing_frequency
    type: int
    sql: ${TABLE}.cc_billing_frequency
  - dimension: cc_payment_amount_cents
    type: int
    sql: ${TABLE}.cc_payment_amount_cents
  - dimension: custom_options
    sql: ${TABLE}.custom_options
  - dimension: flags
    type: int
    sql: ${TABLE}.flags
  - dimension: notes
    sql: ${TABLE}.notes
  - dimension: payment_method
    sql: ${TABLE}.payment_method
  - dimension: plan
    sql: ${TABLE}.plan
  - dimension: preparer_name
    sql: ${TABLE}.preparer_name
  - dimension: preparer_title
    sql: ${TABLE}.preparer_title
  - dimension: renewal_source_id
    type: int
    sql: ${TABLE}.renewal_source_id
  - dimension: state
    sql: ${TABLE}.state
  - dimension: terms
    sql: ${TABLE}.terms
  - dimension: url_key
    sql: ${TABLE}.url_key
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: end
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.end_on
  - dimension_group: offer_expiration
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.offer_expiration
  - dimension_group: renew
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.renew_on
  - dimension_group: start
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.start_on
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • subscriptions.view.lkml
  • subscriptions.view.lookml