data.ml
LKML Edtech

Operational Status Type

Operational Status Type model for edtech.

inferred

Blocks

operational_status_type.view.lkml · 42 lines
inferred 
view: operational_status_type {
  sql_table_name: public.OperationalStatusType ;;

  dimension: id {
    primary_key: yes
    sql: ${TABLE}.Id ;;
  }

  dimension: code_value {
    sql: ${TABLE}.CodeValue ;;
  }

  dimension: description {
    sql: ${TABLE}.Description ;;
  }

  dimension: operational_status_type_id {
    type: int
    sql: ${TABLE}.OperationalStatusTypeId ;;
  }

  dimension: short_description {
    sql: ${TABLE}.ShortDescription ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [id, operational_status_type.id, education_organization.count, operational_status_type.count]
  }
}
operational_status_type.view.lookml · 38 lines
source-preserved 
- view: operational_status_type
  sql_table_name: public.OperationalStatusType
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: code_value
    sql: ${TABLE}.CodeValue
  - dimension: description
    sql: ${TABLE}.Description
  - dimension: operational_status_type_id
    type: int
    sql: ${TABLE}.OperationalStatusTypeId
  - dimension: short_description
    sql: ${TABLE}.ShortDescription
  - dimension_group: create
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreateDate
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastModifiedDate
  - measure: count
    type: count
    drill_fields:
    - id
    - operational_status_type.id
    - education_organization.count
    - operational_status_type.count

Contents

  • operational_status_type.view.lkml
  • operational_status_type.view.lookml