-
Notifications
You must be signed in to change notification settings - Fork 0
/
locations.view.lookml
118 lines (90 loc) · 2.32 KB
/
locations.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
- view: locations
fields:
- dimension: id
primary_key: true
type: number
sql: ${TABLE}.id
- dimension: closet_instructions
type: string
sql: ${TABLE}.closet_instructions
- dimension_group: created
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.created_at
- dimension: email
type: string
sql: ${TABLE}.email
- dimension: hours_friday_end
type: string
sql: ${TABLE}.hours_friday_end
- dimension: hours_friday_start
type: string
sql: ${TABLE}.hours_friday_start
- dimension: hours_monday_end
type: string
sql: ${TABLE}.hours_monday_end
- dimension: hours_monday_start
type: string
sql: ${TABLE}.hours_monday_start
- dimension: hours_saturday_end
type: string
sql: ${TABLE}.hours_saturday_end
- dimension: hours_saturday_start
type: string
sql: ${TABLE}.hours_saturday_start
- dimension: hours_sunday_end
type: string
sql: ${TABLE}.hours_sunday_end
- dimension: hours_sunday_start
type: string
sql: ${TABLE}.hours_sunday_start
- dimension: hours_thursday_end
type: string
sql: ${TABLE}.hours_thursday_end
- dimension: hours_thursday_start
type: string
sql: ${TABLE}.hours_thursday_start
- dimension: hours_tuesday_end
type: string
sql: ${TABLE}.hours_tuesday_end
- dimension: hours_tuesday_start
type: string
sql: ${TABLE}.hours_tuesday_start
- dimension: hours_wednesday_end
type: string
sql: ${TABLE}.hours_wednesday_end
- dimension: hours_wednesday_start
type: string
sql: ${TABLE}.hours_wednesday_start
- dimension: lockbox_code
type: string
sql: ${TABLE}.lockbox_code
- dimension: name
type: string
sql: ${TABLE}.name
- dimension: pack_quota
type: number
sql: ${TABLE}.pack_quota
- dimension: phone_number
type: string
sql: ${TABLE}.phone_number
- dimension: type
type: string
sql: ${TABLE}.type
- dimension_group: updated
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.updated_at
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- name
- activities.count
- communications.count
- fellows.count
- location_closed_dates.count
- location_contacts.count