-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathevent_item_share.view.lookml
135 lines (104 loc) · 2.58 KB
/
event_item_share.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
- view: event_item_share
sql_table_name: qa.event_item_share
fields:
- dimension: id
primary_key: true
type: string
sql: ${TABLE}.id
- dimension: anonymous_id
type: string
sql: ${TABLE}.anonymous_id
- dimension: authors_name
type: string
sql: ${TABLE}.authors_name
- dimension: content_slug
type: string
sql: ${TABLE}.content_slug
- 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: event
type: string
sql: ${TABLE}.event
- dimension: event_text
type: string
sql: ${TABLE}.event_text
- dimension: issue_id
type: int
sql: ${TABLE}.issue_id
- dimension: issue_name
type: string
sql: ${TABLE}.issue_name
- dimension_group: original_timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.original_timestamp
- dimension: partner_id
type: int
sql: ${TABLE}.partner_id
- dimension: partner_name
type: string
sql: ${TABLE}.partner_name
- 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: share_id
type: int
sql: ${TABLE}.share_id
- dimension: share_platform
type: string
sql: ${TABLE}.share_platform
- dimension: share_type
type: string
sql: ${TABLE}.share_type
- dimension_group: timestamp
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.timestamp
- 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
- authors_name
- users.last_name
- users.first_name
- users.id