create revenue_pdt
Change-Id: Ib73787e9d6b451fc3b909f3419d027596af186c0
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} ;;
+# }
+}
