create revenue_pdt_explore
Change-Id: I719d4cfc54d82905934478da9a9ff09e45d57a89
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} ;;
+# }
+# }
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 {
