Generic Stats

view: generic_stats {
  sql_table_name: v2.generic_stats ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: adjusted_rewards_sum {
    type: sum
    sql: ${TABLE}.adjusted_rewards ;;
  }

  measure: adjusted_suggestions_sum {
    type: sum
    sql: ${TABLE}.adjusted_suggestions ;;
  }

  measure: reward_calls_sum {
    type: sum
    sql: ${TABLE}.reward_calls ;;
  }

  measure: rewards_sum {
    description: "The number of goals counted across all visitors to the Lab"
    type: sum
    sql: ${TABLE}.rewards ;;
  }

  measure: suggest_calls_sum {
    type: sum
    sql: ${TABLE}.suggest_calls ;;
  }

  measure: suggestions_sum {
    description: "The number of Unique Visitors served by the Lab"
    type: sum
    sql: ${TABLE}.suggestions ;;
  }

  measure: goal_rate {
    description: "Goals per Unique Visitor"
    type: number
    sql: 100.0 * ${adjusted_rewards_sum} / nullif(${adjusted_suggestions_sum},0) ;;
  }

  measure: lab_reward_value_total {
    type: sum
    sql: ${TABLE}.reward_value_sum ;;
  }

  measure: lab_reward_value_count {
    type: sum
    sql: ${TABLE}.reward_value_cnt ;;
  }

  measure: lab_mean_reward {
    type: number
    sql: ${lab_reward_value_total}/ ${lab_reward_value_count} ;;
  }
}

- view: generic_stats
  sql_table_name: v2.generic_stats
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: adjusted_rewards
    type: number
    sql: ${TABLE}.adjusted_rewards
  - dimension: adjusted_suggestions
    type: number
    sql: ${TABLE}.adjusted_suggestions
  - dimension: code
    sql: ${TABLE}.code
  - dimension: reward_calls
    type: int
    sql: ${TABLE}.reward_calls
  - dimension: reward_value_cnt
    type: int
    sql: ${TABLE}.reward_value_cnt
  - dimension: reward_value_sum
    type: number
    sql: ${TABLE}.reward_value_sum
  - dimension: rewards
    type: number
    sql: ${TABLE}.rewards
  - dimension: suggest_calls
    type: int
    sql: ${TABLE}.suggest_calls
  - dimension: suggestions
    type: int
    sql: ${TABLE}.suggestions
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: date
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.date
  - measure: count
    type: count
    drill_fields:
    - id
  - measure: adjusted_rewards_sum
    type: sum
    sql: ${TABLE}.adjusted_rewards
  - measure: adjusted_suggestions_sum
    type: sum
    sql: ${TABLE}.adjusted_suggestions
  - measure: reward_calls_sum
    type: sum
    sql: ${TABLE}.reward_calls
  - measure: rewards_sum
    type: sum
    description: The number of goals counted across all visitors to the Lab
    sql: ${TABLE}.rewards
  - measure: suggest_calls_sum
    type: sum
    sql: ${TABLE}.suggest_calls
  - measure: suggestions_sum
    type: sum
    description: The number of Unique Visitors served by the Lab
    sql: ${TABLE}.suggestions
  - measure: goal_rate
    type: number
    description: Goals per Unique Visitor
    sql: 100.0 * ${adjusted_rewards_sum} / nullif(${adjusted_suggestions_sum},0)
  - measure: lab_reward_value_total
    type: sum
    sql: ${TABLE}.reward_value_sum
  - measure: lab_reward_value_count
    type: sum
    sql: ${TABLE}.reward_value_cnt
  - measure: lab_mean_reward
    type: number
    sql: ${lab_reward_value_total}/ ${lab_reward_value_count}