created 3rd view
Change-Id: Ife14840c7c26092aea20513252c70a9389783ff8
(cherry picked from commit 29a99110243e8a8682602b6bbf5685e880d1da5e)
diff --git a/3rd_view.view.lkml b/3rd_view.view.lkml
new file mode 100644
index 0000000..a0e41c9
--- /dev/null
+++ b/3rd_view.view.lkml
@@ -0,0 +1,69 @@
+view: 3rd_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: 3rd_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} ;;
+# }
+# }
