LKML Health marketing

Time

Time model for health marketing.

inferred

LKML LookML

time.view.lkml · 64 lines

inferred

view: time {
  sql_table_name: data_warehouse.DWIMP_TIME ;;

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

  dimension: flex_cat1 {
    sql: ${TABLE}.FLEX_CAT1 ;;
  }

  dimension: flex_cat2 {
    sql: ${TABLE}.FLEX_CAT2 ;;
  }

  dimension: flex_cat3 {
    sql: ${TABLE}.FLEX_CAT3 ;;
  }

  dimension: hour_of_day {
    type: int
    sql: ${TABLE}.HOUR_OF_DAY ;;
  }

  dimension: minutes_of_hour {
    type: int
    sql: ${TABLE}.MINUTES_OF_HOUR ;;
  }

  dimension: sec_of_day {
    type: int
    sql: ${TABLE}.SEC_OF_DAY ;;
  }

  dimension: sec_of_minute {
    type: int
    sql: ${TABLE}.SEC_OF_MINUTE ;;
  }

  dimension: time_meridian {
    sql: ${TABLE}.TIME_MERIDIAN ;;
  }

  dimension: time_of_day {
    sql: ${TABLE}.TIME_OF_DAY ;;
  }

  dimension: working_day {
    sql: ${TABLE}.WORKING_DAY ;;
  }

  measure: count {
    type: count
    drill_fields: [time_id, takes.count]
  }

  measure: hours_count {
    type: count_distinct
    drill_fields: [takes.hourly_media_set*]
    sql: ${TABLE}.hour_of_day ;;
  }
}

time.view.lookml · 41 lines

source-preserved

- view: time
  sql_table_name: data_warehouse.DWIMP_TIME
  fields:
  - dimension: time_id
    type: int
    primary_key: true
    sql: ${TABLE}.TIME_ID
  - dimension: flex_cat1
    sql: ${TABLE}.FLEX_CAT1
  - dimension: flex_cat2
    sql: ${TABLE}.FLEX_CAT2
  - dimension: flex_cat3
    sql: ${TABLE}.FLEX_CAT3
  - dimension: hour_of_day
    type: int
    sql: ${TABLE}.HOUR_OF_DAY
  - dimension: minutes_of_hour
    type: int
    sql: ${TABLE}.MINUTES_OF_HOUR
  - dimension: sec_of_day
    type: int
    sql: ${TABLE}.SEC_OF_DAY
  - dimension: sec_of_minute
    type: int
    sql: ${TABLE}.SEC_OF_MINUTE
  - dimension: time_meridian
    sql: ${TABLE}.TIME_MERIDIAN
  - dimension: time_of_day
    sql: ${TABLE}.TIME_OF_DAY
  - dimension: working_day
    sql: ${TABLE}.WORKING_DAY
  - measure: count
    type: count
    drill_fields:
    - time_id
    - takes.count
  - measure: hours_count
    type: count_distinct
    drill_fields:
    - takes.hourly_media_set*
    sql: ${TABLE}.hour_of_day

time.view.lkml
time.view.lookml

Time

Blocks

Contents