Create max_date view

Change-Id: Ieeeaae6e2fa03c8deb998693de4b83b2244240b3

views/revenue/max_date.view.lkml

diff --git a/views/revenue/max_date.view.lkml b/views/revenue/max_date.view.lkml
new file mode 100644
index 0000000..f25aefb
--- /dev/null
+++ b/views/revenue/max_date.view.lkml
@@ -0,0 +1,31 @@
+
+view: max_date {
+  derived_table: {
+    sql: SELECT max_partition_date AS max_date_minus_2
+         FROM `concord-test.stagingservice_gcc.gcc_revenue_latest_partition_view`
+         GROUP BY 1;;
+  }
+########## PRIMARY KEYS ############
+  dimension: pk {
+    description: "Primary key.  This table should only ever have one row, so any dimension should be the primary key."
+    hidden: yes
+    primary_key: yes
+    sql: ${max_date_minus_2_raw} ;;
+  }
+########## DIMENSIONS ############
+  dimension_group: max_date_minus_2 {
+    description: "Calculates the latest date in the Revenue table and subtracts 2 days"
+    hidden: yes
+    type: time
+    datatype: date
+    timeframes: [raw, date, day_of_month, day_of_year, month, month_name, week]
+    sql: CAST(${TABLE}.max_date_minus_2 AS DATE) ;;
+    convert_tz: no
+  }
+  dimension: max_date_minus_2_day_of_quarter {
+    hidden: yes
+    description: "Day of quarter"
+    type: number
+    sql: DATE_DIFF(${max_date_minus_2_raw}, DATE_TRUNC(${max_date_minus_2_raw}, QUARTER), DAY) ;;
+  }
+}