add segment and pdt time
Change-Id: I8af9d8f7180ffa84e684da2da2a6e5dd19fe05d0
diff --git a/views/revenue_pdt.view.lkml b/views/revenue_pdt.view.lkml
index 75c373f..f5a9cab 100644
--- a/views/revenue_pdt.view.lkml
+++ b/views/revenue_pdt.view.lkml
@@ -3,7 +3,8 @@
# # Or, you could make this view a derived table, like this:
derived_table: {
sql: SELECT
- 'foo' as foo
+ 'foo' as foo,
+ segment
FROM gcc_internal.revenue
;;
sql_trigger_value: SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP());;
@@ -16,6 +17,17 @@
type: string
sql: ${TABLE}.foo ;;
}
+
+ dimension: segment {
+ type: string
+ sql: ${TABLE}.segment ;;
+
+ }
+ dimension: pdt_time {
+ type: string
+ sql: format_timestamp('%F %T', current_timestamp(), 'America/Los_Angeles') ;;
+
+ }
#
# dimension: lifetime_orders {
# description: "The total number of orders for each user"
