data.ml
LKML Saas analytics

Sessions A

Sessions A model for saas analytics.

inferred

Blocks

sessions_a.view.lkml · 60 lines
inferred 
view: sessions_a {
  sql_table_name: public.sessions ;;

  dimension: session_id {
    primary_key: yes
    sql: ${TABLE}.session_id ;;
  }

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

  dimension: device_type {
    label: "device_type"
    hidden: yes
    sql: ${TABLE}.device_type ;;
  }

  dimension: device_type1 {
    label: "Device Type"
    sql: CASE WHEN ${device_type} IS NULL AND ${sessions_a.ua} = <% parameter placeholder_ua_value %> THEN 'FS App'
     WHEN ${device_type} IS NULL THEN 'other'
     ELSE ${device_type}
END ;;
  }

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [session_id, events_raw.count]
  }
}
sessions_a.view.lookml · 38 lines
source-preserved 
- view: sessions_a
  sql_table_name: public.sessions
  fields:
  - dimension: session_id
    primary_key: true
    sql: ${TABLE}.session_id
  - dimension: browser
    sql: ${TABLE}.browser
  - dimension: device_type
    hidden: true
    label: device_type
    sql: ${TABLE}.device_type
  - dimension: device_type1
    label: Device Type
    sql: CASE WHEN ${device_type} IS NULL AND ${sessions_a.ua} = <% parameter placeholder_ua_value %> THEN 'FS App'
     WHEN ${device_type} IS NULL THEN 'other'
     ELSE ${device_type}
END
  - dimension: id
    type: int
    sql: ${TABLE}.id
  - dimension: medium
    sql: ${TABLE}.medium
  - dimension: landing_url
    sql: ${TABLE}.landing_url
  - dimension: os
    sql: ${TABLE}.os
  - dimension: referer
    sql: ${TABLE}.referer
  - dimension: source
    sql: ${TABLE}.source
  - dimension: ua
    sql: ${TABLE}.ua
  - measure: count
    type: count
    drill_fields:
    - session_id
    - events_raw.count

Contents

  • sessions_a.view.lkml
  • sessions_a.view.lookml