create revenue_pdt

Change-Id: Ib73787e9d6b451fc3b909f3419d027596af186c0

views/revenue_pdt.view.lkml

diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
new file mode 100644
index 0000000..35631ea
--- /dev/null
+++ b/views/revenue_pdt.view.lkml
@@ -0,0 +1,37 @@
+view: revenue_pdt {
+  label: "revenue_pdt view label"
+#   # Or, you could make this view a derived table, like this:
+  derived_table: {
+    sql: SELECT
+        'foo' as foo
+      FROM gcc_internal.revenue
+      ;;
+    sql_trigger_value: SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP());;
+  }
+#
+#   # Define your dimensions and measures here, like this:
+  dimension: foo {
+    description: "foo"
+    type: string
+    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} ;;
+#   }
+}