data.ml
LKML Consulting it

Calendar

Calendar model for consulting it.

inferred

Blocks

calendar.view.lkml · 85 lines
inferred 
view: calendar {
  sql_table_name: t_calendar ;;

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

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

  dimension: d_datum_dateonly {
    type: date_date
    sql: ${TABLE}.d_datum ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [weekdayname, monthname]
  }
}
calendar.view.lookml · 54 lines
source-preserved 
- view: calendar
  sql_table_name: t_calendar
  fields:
  - dimension: american_holiday
    sql: ${TABLE}.american_holiday
  - dimension: calendarweek
    type: number
    sql: ${TABLE}.calendarweek
  - dimension: d_datum_dateonly
    type: date_date
    sql: ${TABLE}.d_datum
  - dimension: day
    type: number
    sql: ${TABLE}.day
  - dimension: dayofyear
    type: number
    sql: ${TABLE}.dayofyear
  - dimension: formatteddate
    sql: ${TABLE}.formatteddate
  - dimension: month
    type: number
    sql: ${TABLE}.month
  - dimension: monthname
    sql: ${TABLE}.monthname
  - dimension: quartal
    sql: ${TABLE}.quartal
  - dimension: weekdayname
    sql: ${TABLE}.weekdayname
  - dimension: weekend
    sql: ${TABLE}.weekend
  - dimension: weekend_holiday_day
    sql: ${TABLE}.weekend_holiday_day
  - dimension: year
    type: number
    sql: ${TABLE}.year
  - dimension: yearcalendarweek
    sql: ${TABLE}.yearcalendarweek
  - dimension: yearmonth
    sql: ${TABLE}.yearmonth
  - dimension: yearquartal
    sql: ${TABLE}.yearquartal
  - dimension_group: datefield
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.d_datum
  - measure: count
    type: count
    drill_fields:
    - weekdayname
    - monthname

Contents

  • calendar.view.lkml
  • calendar.view.lookml