create revenue_pdt_explore

Change-Id: I719d4cfc54d82905934478da9a9ff09e45d57a89

explores/revenue_pdt_explore.view.lkml

diff --git a/explores/revenue_pdt_explore.view.lkml b/explores/revenue_pdt_explore.view.lkml
new file mode 100644
index 0000000..d2d602f
--- /dev/null
+++ b/explores/revenue_pdt_explore.view.lkml
@@ -0,0 +1,45 @@
+
+include: "../views/*.view.lkml"
+explore: revenue_pdt_explore {
+  view_name: revenue_pdt
+  label: "revenue_pdt_explore label bis"
+}
+
+# view: revenue_pdt_explore {
+#   # 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} ;;
+#   }
+# }

views/revenue_pdt.view.lkml

diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
index 35631ea..dbcf868 100644
--- a/views/revenue_pdt.view.lkml
+++ b/views/revenue_pdt.view.lkml
@@ -11,9 +11,9 @@
 #
 #   # Define your dimensions and measures here, like this:
   dimension: foo {
-    description: "foo"
+    description: "foo dimension description"
     type: string
-    sql: ${TABLE}.user_id ;;
+    sql: ${TABLE}.foo ;;
   }
 #
 #   dimension: lifetime_orders {