########################
# Purpose: L4C Testing
# Author: Data Team
# Date: 05/24/2021
#######################

view: testing {

  derived_table: {
    sql:
      SELECT 200 AS value, CURRENT_TIMESTAMP() AS time
      UNION ALL
      SELECT 100 AS value, CURRENT_TIMESTAMP() AS time
      ;;
  }

  dimension: value_raw {
    hidden: yes
    type: yesno
    sql: ${TABLE}.value ;;
  }

  dimension_group: time {
    hidden: yes
    datatype: timestamp
    type: time
    sql: ${TABLE}.time ;;
  }


  measure: value {
    type: sum
    sql: ${value_raw} ;;

  }

}