data.ml
LookML Analytics shopping

D4 Metrics Tall

D4 Metrics Tall model for analytics shopping.

source-preserved

Blocks

d4_metrics_tall.view.lkml · 66 lines
inferred 
view: d4_metrics_tall {
  sql_table_name: public.d4_metrics_tall ;;

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

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

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

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

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

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

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

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

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

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

  measure: average_value {
    type: average
    sql: ${value} ;;
  }

  measure: total_value {
    type: sum
    sql: ${value} ;;
  }

  measure: count {
    type: count
    drill_fields: [client_name]
  }
}
d4_metrics_tall.view.lookml · 49 lines
source-preserved 
- view: d4_metrics_tall
  sql_table_name: public.d4_metrics_tall
  fields:
  - dimension: client_name
    sql: ${TABLE}.client_name
  - dimension: confidence_interval_high
    type: number
    sql: ${TABLE}.confidence_interval_high
  - dimension: confidence_interval_low
    type: number
    sql: ${TABLE}.confidence_interval_low
  - dimension: hierarchy_node_id
    sql: ${TABLE}.hierarchy_node_id
  - dimension: metric
    sql: ${TABLE}.metric
  - dimension: period
    sql: ${TABLE}.period
  - dimension: sample_size
    type: number
    sql: ${TABLE}.sample_size
  - dimension: value
    type: number
    sql: ${TABLE}.value
  - dimension_group: birth
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.birth
  - dimension_group: period_earliest
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.period_earliest
  - measure: average_value
    type: average
    sql: ${value}
  - measure: total_value
    type: sum
    sql: ${value}
  - measure: count
    type: count
    drill_fields:
    - client_name

Contents

  • d4_metrics_tall.view.lkml
  • d4_metrics_tall.view.lookml