create revenue_view

Change-Id: If21e72c35faa0d5167b9f44990cbc5e76b689467

hdeist-pdt.model.lkml

diff --git a/hdeist-pdt.model.lkml b/hdeist-pdt.model.lkml
deleted file mode 100644
index 61cebad..0000000
--- a/hdeist-pdt.model.lkml
+++ /dev/null
@@ -1,13 +0,0 @@
-connection: "fdm_pdt"
-
-include: "/*.view"
-include: "//hdeist-fdm/uli_explore.explore"
-datagroup: pdt_datagroup {
-  max_cache_age: "1 hour"
-}
-
-persist_with: pdt_datagroup
-
-explore: pru {}
-
-explore: uli_view2 {}

manifest.lkml

diff --git a/manifest.lkml b/manifest.lkml
deleted file mode 100644
index a9677a8..0000000
--- a/manifest.lkml
+++ /dev/null
@@ -1,7 +0,0 @@
-
-
-project_name: "hdeist-pdt"
-
-local_dependency: {
-  project: "hdeist-fdm"
-}

pru.view.lkml

diff --git a/pru.view.lkml b/pru.view.lkml
deleted file mode 100644
index a2643d6..0000000
--- a/pru.view.lkml
+++ /dev/null
@@ -1,30 +0,0 @@
-include: "//hdeist-fdm/uli_explore.explore"
-
-view: pru {
-  derived_table : {
-    persist_for: "24 hours"
-    explore_source: uli_view {
-      column: partition_date {
-        field: uli_view.partition_date
-      }
-      column: usage_date {
-        field: uli_view.usage_date
-      }
-      column: zork {
-        field: uli_view.zork
-      }
-    }
-  }
-  dimension: partition_date {
-    type: string
-    sql: ${TABLE}.partition_date ;;
-  }
-dimension: usage_date {
-  type: string
-  sql: ${TABLE}.usage_date ;;
-}
-dimension: zork {
-  type: string
-  sql: ${TABLE}.zork ;;
-}
-}

uli_view2.view.lkml

diff --git a/uli_view2.view.lkml b/uli_view2.view.lkml
deleted file mode 100644
index 18d6d1f..0000000
--- a/uli_view2.view.lkml
+++ /dev/null
@@ -1,30 +0,0 @@
-
-
-view: uli_view2 {
-  sql_table_name: `irvine-sbx.fdm.uli` ;;
-
-  dimension: partition_date {
-    type: string
-    sql: ${TABLE}.partition_date ;;
-  }
-
-  dimension: service_id {
-    type: string
-    sql: ${TABLE}.service_id ;;
-  }
-
-  dimension: usage_date {
-    type: date
-    datatype: date
-    sql: ${TABLE}.usage_date ;;
-  }
-
-  dimension: magoo {
-    type: string
-    sql:  'magoo' ;;
-  }
-  measure: count {
-    type: count
-  }
-
-}

views/.gitkeep

diff --git a/views/.gitkeep b/views/.gitkeep
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/views/.gitkeep

views/revenue_view.view.lkml

diff --git a/views/revenue_view.view.lkml b/views/revenue_view.view.lkml
new file mode 100644
index 0000000..04083e4
--- /dev/null
+++ b/views/revenue_view.view.lkml
@@ -0,0 +1,69 @@
+view: revenue_view {
+  # # You can specify the table name if it's different from the view name:
+  sql_table_name: gcc_internal.revenue ;;
+  #
+  # # Define your dimensions and measures here, like this:
+  dimension: usage_date {
+    description: "usage date"
+    type: date
+    sql: ${TABLE}.usage_date ;;
+  }
+  #
+  # 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: revenue_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} ;;
+#   }
+# }