updating 5th v1
Change-Id: Id253cad01be65a6852c0b799584ec2d32d7a48c2
(cherry picked from commit 31d96b04e95fa4acd331975a694433d51bf699e7)
diff --git a/4th_view.view.lkml b/4th_view.view.lkml
index 59ca3aa..53074fd 100644
--- a/4th_view.view.lkml
+++ b/4th_view.view.lkml
@@ -1,69 +1 @@
-view: 4th_view {
- # # You can specify the table name if it's different from the view name:
- # sql_table_name: my_schema_name.tester ;;
- #
- # # Define your dimensions and measures here, like this:
- # dimension: user_id {
- # description: "Unique ID for each user that has ordered"
- # type: number
- # sql: ${TABLE}.user_id ;;
- # }
- #
- # dimension: lifetime_orders {
- # description: "The total number of orders for each user"
- # type: number
- # sql: ${TABLE}.lifetime_orders ;;
- # }
- #
- # dimension_group: most_recent_purchase {
- # description: "The date when each user last ordered"
- # type: time
- # timeframes: [date, week, month, year]
- # sql: ${TABLE}.most_recent_purchase_at ;;
- # }
- #
- # measure: total_lifetime_orders {
- # description: "Use this for counting lifetime orders across many users"
- # type: sum
- # sql: ${lifetime_orders} ;;
- # }
-}
-
-# view: 4th_view {
-# # Or, you could make this view a derived table, like this:
-# derived_table: {
-# sql: SELECT
-# user_id as user_id
-# , COUNT(*) as lifetime_orders
-# , MAX(orders.created_at) as most_recent_purchase_at
-# FROM orders
-# GROUP BY user_id
-# ;;
-# }
-#
-# # Define your dimensions and measures here, like this:
-# dimension: user_id {
-# description: "Unique ID for each user that has ordered"
-# type: number
-# sql: ${TABLE}.user_id ;;
-# }
-#
-# dimension: lifetime_orders {
-# description: "The total number of orders for each user"
-# type: number
-# sql: ${TABLE}.lifetime_orders ;;
-# }
-#
-# dimension_group: most_recent_purchase {
-# description: "The date when each user last ordered"
-# type: time
-# timeframes: [date, week, month, year]
-# sql: ${TABLE}.most_recent_purchase_at ;;
-# }
-#
-# measure: total_lifetime_orders {
-# description: "Use this for counting lifetime orders across many users"
-# type: sum
-# sql: ${lifetime_orders} ;;
-# }
-# }
+view: 4th_view { }
diff --git a/5th_view.view.lkml b/5th_view.view.lkml
index 09ff50d..d5bd488 100644
--- a/5th_view.view.lkml
+++ b/5th_view.view.lkml
@@ -1,69 +1 @@
-view: 5th_view {
- # # You can specify the table name if it's different from the view name:
- # sql_table_name: my_schema_name.tester ;;
- #
- # # Define your dimensions and measures here, like this:
- # dimension: user_id {
- # description: "Unique ID for each user that has ordered"
- # type: number
- # sql: ${TABLE}.user_id ;;
- # }
- #
- # dimension: lifetime_orders {
- # description: "The total number of orders for each user"
- # type: number
- # sql: ${TABLE}.lifetime_orders ;;
- # }
- #
- # dimension_group: most_recent_purchase {
- # description: "The date when each user last ordered"
- # type: time
- # timeframes: [date, week, month, year]
- # sql: ${TABLE}.most_recent_purchase_at ;;
- # }
- #
- # measure: total_lifetime_orders {
- # description: "Use this for counting lifetime orders across many users"
- # type: sum
- # sql: ${lifetime_orders} ;;
- # }
-}
-
-# view: 5th_view {
-# # Or, you could make this view a derived table, like this:
-# derived_table: {
-# sql: SELECT
-# user_id as user_id
-# , COUNT(*) as lifetime_orders
-# , MAX(orders.created_at) as most_recent_purchase_at
-# FROM orders
-# GROUP BY user_id
-# ;;
-# }
-#
-# # Define your dimensions and measures here, like this:
-# dimension: user_id {
-# description: "Unique ID for each user that has ordered"
-# type: number
-# sql: ${TABLE}.user_id ;;
-# }
-#
-# dimension: lifetime_orders {
-# description: "The total number of orders for each user"
-# type: number
-# sql: ${TABLE}.lifetime_orders ;;
-# }
-#
-# dimension_group: most_recent_purchase {
-# description: "The date when each user last ordered"
-# type: time
-# timeframes: [date, week, month, year]
-# sql: ${TABLE}.most_recent_purchase_at ;;
-# }
-#
-# measure: total_lifetime_orders {
-# description: "Use this for counting lifetime orders across many users"
-# type: sum
-# sql: ${lifetime_orders} ;;
-# }
-# }
+view: 5th_view { }
