adding 6th view

Change-Id: I884725bf9185556f6e2db3109b9753da6d825845
(cherry picked from commit 967fd1b590eecb0c0f53a223af4217af01c78da3)

6th_view.view.lkml

diff --git a/6th_view.view.lkml b/6th_view.view.lkml
new file mode 100644
index 0000000..1467b30
--- /dev/null
+++ b/6th_view.view.lkml
@@ -0,0 +1,69 @@
+view: 6th_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: 6th_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} ;;
+#   }
+# }