data.ml
LKML Digital journalism

Mp3 Downloads

Mp3 Downloads model for digital journalism.

inferred

Blocks

mp3_downloads.view.lkml · 35 lines
inferred 
view: mp3_downloads {
  sql_table_name: companyplus.mp3_download ;;

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

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

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

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

  dimension: pk {
    primary_key: yes
    hidden: yes
    sql: ${TABLE}.dt || ${TABLE}.mp3_url || ${TABLE}.uuid || ${TABLE}.ip || ${TABLE}.range_header ;;
  }

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

  measure: count {
    type: count
  }
}
mp3_downloads.view.lookml · 25 lines
source-preserved 
- view: mp3_downloads
  sql_table_name: companyplus.mp3_download
  fields:
  - dimension: mp3_url
    sql: ${TABLE}.mp3_url
  - dimension: uuid
    sql: ${TABLE}.uuid
  - dimension: ip
    sql: ${TABLE}.ip
  - dimension: range_header
    sql: ${TABLE}.range_header
  - dimension: pk
    primary_key: true
    hidden: true
    sql: ${TABLE}.dt || ${TABLE}.mp3_url || ${TABLE}.uuid || ${TABLE}.ip || ${TABLE}.range_header
  - dimension_group: download
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dt
  - measure: count
    type: count

Contents

  • mp3_downloads.view.lkml
  • mp3_downloads.view.lookml