-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathidentifies.view.lookml
151 lines (116 loc) · 3 KB
/
identifies.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
- view: identifies
sql_table_name: qa.identifies
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: anonymous_id
type: string
sql: ${TABLE}.anonymous_id
- dimension: available_points
type: number
sql: ${TABLE}.available_points
- dimension: context_campaign_medium
type: string
sql: ${TABLE}.context_campaign_medium
- dimension: context_campaign_name
type: string
sql: ${TABLE}.context_campaign_name
- dimension: context_campaign_source
type: string
sql: ${TABLE}.context_campaign_source
- 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_search
type: string
sql: ${TABLE}.context_page_search
- 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: country
type: string
sql: ${TABLE}.country
- dimension: created_at
type: string
sql: ${TABLE}.created_at
- dimension: email
type: string
sql: ${TABLE}.email
- dimension: email_confirmed
type: yesno
sql: ${TABLE}.email_confirmed
- dimension: first_name
type: string
sql: ${TABLE}.first_name
- dimension: has_acted_to_end_poverty
type: yesno
sql: ${TABLE}.has_acted_to_end_poverty
- dimension: last_name
type: string
sql: ${TABLE}.last_name
- dimension: locale
type: string
sql: ${TABLE}.locale
- dimension_group: original_timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.original_timestamp
- dimension: postal_code
type: string
sql: ${TABLE}.postal_code
- 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_group: timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.timestamp
- dimension: total_earned_points
type: number
sql: ${TABLE}.total_earned_points
- 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
- last_name
- first_name
- context_library_name
- context_campaign_name
- users.last_name
- users.first_name
- users.id