data.ml
LookML Digital journalism

Commercial Node Raw

Commercial Node Raw model for digital journalism.

source-preserved

Blocks

commercial_node_raw.view.lkml · 44 lines
inferred 
view: commercial_node_raw {
  sql_table_name: traffic.commercial_node_raw ;;

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

  dimension: section {
    sql: split_part(${TABLE}.commercial_node, '/', 1) ;;
  }

  dimension: subsection {
    sql: split_part(${TABLE}.commercial_node, '/', 2) ;;
  }

  dimension: united_states {
    type: yesno
    sql: ${TABLE}.country = 'usa' ;;
  }

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

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

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

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

  measure: page_views {
    type: sum
    sql: ${TABLE}.page_views ;;
  }
}
commercial_node_raw.view.lookml · 29 lines
source-preserved 
- view: commercial_node_raw
  sql_table_name: traffic.commercial_node_raw
  fields:
  - dimension: commercial_node
    sql: ${TABLE}.commercial_node
  - dimension: section
    sql: split_part(${TABLE}.commercial_node, '/', 1)
  - dimension: subsection
    sql: split_part(${TABLE}.commercial_node, '/', 2)
  - dimension: united_states
    type: yesno
    sql: ${TABLE}.country = 'usa'
  - dimension: content_type
    sql: ${TABLE}.content_type
  - dimension: country
    sql: ${TABLE}.country
  - dimension: device
    sql: ${TABLE}.device
  - dimension_group: dt
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dt
  - measure: page_views
    type: sum
    sql: ${TABLE}.page_views

Contents

  • commercial_node_raw.view.lkml
  • commercial_node_raw.view.lookml