data.ml
LKML Subscription reading

Revenue Data

Revenue Data model for subscription reading.

inferred

Blocks

revenue_data.view.lkml · 37 lines
inferred 
view: revenue_data {
  sql_table_name: warehouse.revenue_reports ;;

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
revenue_data.view.lookml · 27 lines
source-preserved 
- view: revenue_data
  sql_table_name: warehouse.revenue_reports
  fields:
  - dimension: earned_yesno
    type: yesno
    sql: COALESCE(${TABLE}.earned_at, '') != ''
  - dimension: earned_week
    type: date
    sql: to_date(date_sub(${TABLE}.earned_at, (dayofweek(${TABLE}.earned_at)+5)%7))
  - dimension: gross_revenue
    type: int
    sql: ${TABLE}.gross_revenue
  - dimension: revenue_source
    sql: ${TABLE}.revenue_source
  - dimension: word_user_id
    type: int
    sql: ${TABLE}.word_user_id
  - dimension_group: earned
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.earned_at
  - measure: count
    type: count

Contents

  • revenue_data.view.lkml
  • revenue_data.view.lookml