data.ml
LKML Saas analytics

Rewards

Rewards model for saas analytics.

inferred

Blocks

rewards.view.lkml · 54 lines
inferred 
view: rewards {
  sql_table_name: v2.rewards ;;

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }

  measure: rewards_count {
    label: "Rewards over time"
    type: sum
    sql: ${TABLE}.reward ;;
  }

  measure: adjusted_rewards_count {
    label: "Adjusted Rewards over time"
    type: sum
    sql: ${TABLE}.adjusted_reward ;;
  }
}
rewards.view.lookml · 39 lines
source-preserved 
- view: rewards
  sql_table_name: v2.rewards
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: adjusted_reward
    type: number
    sql: ${TABLE}.adjusted_reward
  - dimension: context
    sql: ${TABLE}.context
  - dimension: reward
    type: number
    sql: ${TABLE}.reward
  - dimension: reward_token
    sql: ${TABLE}.reward_token
  - dimension: variant_code
    sql: ${TABLE}.variant_code
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count
    drill_fields:
    - id
  - measure: rewards_count
    type: sum
    label: Rewards over time
    sql: ${TABLE}.reward
  - measure: adjusted_rewards_count
    type: sum
    label: Adjusted Rewards over time
    sql: ${TABLE}.adjusted_reward

Contents

  • rewards.view.lkml
  • rewards.view.lookml