updating 5th v1 Change-Id: Id253cad01be65a6852c0b799584ec2d32d7a48c2
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 { }