-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathevent_action_take.view.lookml
162 lines (124 loc) · 3.04 KB
/
event_action_take.view.lookml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
- view: event_action_take
sql_table_name: qa.event_action_take
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: action_id
type: string
sql: ${TABLE}.action_id
- dimension: action_type
type: string
sql: ${TABLE}.action_type
- dimension: anonymous_id
type: string
sql: ${TABLE}.anonymous_id
- dimension: category
type: string
sql: ${TABLE}.category
- dimension: collect_data_share
type: yesno
sql: ${TABLE}.collect_data_share
- dimension: context_ip
type: string
sql: ${TABLE}.context_ip
- dimension: context_library_name
type: string
sql: ${TABLE}.context_library_name
- dimension: context_library_version
type: string
sql: ${TABLE}.context_library_version
- dimension: context_page_path
type: string
sql: ${TABLE}.context_page_path
- dimension: context_page_referrer
type: string
sql: ${TABLE}.context_page_referrer
- dimension: context_page_title
type: string
sql: ${TABLE}.context_page_title
- dimension: context_page_url
type: string
sql: ${TABLE}.context_page_url
- dimension: context_user_agent
type: string
sql: ${TABLE}.context_user_agent
- dimension: description
type: string
sql: ${TABLE}.description
- dimension: email_to
type: string
sql: ${TABLE}.email_to
- dimension: event
type: string
sql: ${TABLE}.event
- dimension: event_text
type: string
sql: ${TABLE}.event_text
- dimension: has_completed
type: yesno
sql: ${TABLE}.has_completed
- dimension: issue_id
type: string
sql: ${TABLE}.issue_id
- dimension: issue_name
type: string
sql: ${TABLE}.issue_name
- dimension: mobile_only
type: yesno
sql: ${TABLE}.mobile_only
- dimension_group: original_timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.original_timestamp
- dimension: page_type
type: string
sql: ${TABLE}.page_type
- dimension: partner_id
type: string
sql: ${TABLE}.partner_id
- dimension: partner_name
type: string
sql: ${TABLE}.partner_name
- dimension: points
type: number
sql: ${TABLE}.points
- dimension_group: received
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.received_at
- dimension_group: sent
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.sent_at
- dimension: slug
type: string
sql: ${TABLE}.slug
- dimension_group: timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.timestamp
- dimension: title
type: string
sql: ${TABLE}.title
- dimension: user_id
type: string
# hidden: true
sql: ${TABLE}.user_id
- dimension: uuid
type: int
sql: ${TABLE}.uuid
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- partner_name
- issue_name
- context_library_name
- users.last_name
- users.first_name
- users.id