-
Notifications
You must be signed in to change notification settings - Fork 0
/
fellows.view.lookml
137 lines (108 loc) · 2.7 KB
/
fellows.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
- view: fellows
fields:
- dimension: id
primary_key: true
type: number
sql: ${TABLE}.id
- dimension: activity_eligibility_overrides
type: string
sql: ${TABLE}.activity_eligibility_overrides
- dimension: activity_notification_blacklist
type: string
sql: ${TABLE}.activity_notification_blacklist
- dimension: balanced_bank_account_uri
type: string
sql: ${TABLE}.balanced_bank_account_uri
- dimension: balanced_customer_uri
type: string
sql: ${TABLE}.balanced_customer_uri
- dimension: bill_dotcom_vendor_id
type: string
sql: ${TABLE}.bill_dotcom_vendor_id
- dimension: bio
type: string
sql: ${TABLE}.bio
- dimension: blazer_enabled
type: yesno
sql: ${TABLE}.blazer_enabled
- dimension_group: created
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.created_at
- dimension: default_availability_shifts
type: string
sql: ${TABLE}.default_availability_shifts
- dimension: email
type: string
sql: ${TABLE}.email
- dimension: ip_group
type: number
sql: ${TABLE}.ip_group
- dimension: location_id
type: number
# hidden: true
sql: ${TABLE}.location_id
- dimension: mobile_beta_access
type: yesno
sql: ${TABLE}.mobile_beta_access
- dimension: name
type: string
sql: ${TABLE}.name
- dimension: needs_profile_pic
type: yesno
sql: ${TABLE}.needs_profile_pic
- dimension: parent_id
type: number
sql: ${TABLE}.parent_id
- dimension: phone_number
type: string
sql: ${TABLE}.phone_number
- dimension: photo
type: string
sql: ${TABLE}.photo
- dimension: rate
type: number
sql: ${TABLE}.rate
- dimension: rating
type: number
sql: ${TABLE}.rating
- dimension: rating_count
type: number
sql: ${TABLE}.rating_count
- dimension: type
type: string
sql: ${TABLE}.type
- dimension_group: updated
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.updated_at
- dimension: uuid
type: string
sql: ${TABLE}.uuid
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- name
- locations.name
- locations.id
- activities.count
- activity_histories.count
- availability_histories.count
- communications.count
- fellow_availability_shifts.count
- fellow_available_teams.count
- fellow_properties.count
- fellows_service_areas.count
- issue_reports.count
- lockbox_codes.count
- message_activities.count
- messages.count
- notes.count
- promotions.count
- skills.count
- vendors.count
- vendor_transactions.count