-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlistings.view.lookml
134 lines (103 loc) · 2.57 KB
/
listings.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
- view: listings
fields:
- dimension: id
primary_key: true
type: number
sql: ${TABLE}.id
- dimension: account_id
type: number
# hidden: true
sql: ${TABLE}.account_id
- dimension: active
type: yesno
sql: ${TABLE}.active
- dimension: api
type: yesno
sql: ${TABLE}.api
- dimension: archived
type: yesno
sql: ${TABLE}.archived
- dimension_group: archived
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.archived_at
- dimension: archived_by_id
type: number
sql: ${TABLE}.archived_by_id
- dimension: archived_reason
type: string
sql: ${TABLE}.archived_reason
- dimension: confirmed_by_user
type: yesno
sql: ${TABLE}.confirmed_by_user
- dimension_group: created
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.created_at
- dimension: encrypted_password
type: string
sql: ${TABLE}.encrypted_password
- dimension: error
type: string
sql: ${TABLE}.error
- dimension: ignore_commission
type: yesno
sql: ${TABLE}.ignore_commission
- dimension: import_listing_text
type: yesno
sql: ${TABLE}.import_listing_text
- dimension: listing_confirmation_number
type: string
sql: ${TABLE}.listing_confirmation_number
- dimension: messages_count
type: number
sql: ${TABLE}.messages_count
- dimension: owner
type: number
sql: ${TABLE}.owner
- dimension: price_shift
type: number
sql: ${TABLE}.price_shift
- dimension: property_id
type: number
sql: ${TABLE}.property_id
- dimension: property_key
type: string
sql: ${TABLE}.property_key
- dimension: push_prices
type: yesno
sql: ${TABLE}.push_prices
- dimension: rating
type: number
sql: ${TABLE}.rating
- dimension: service_full_id
type: string
sql: ${TABLE}.service_full_id
- dimension: service_property_id
type: string
sql: ${TABLE}.service_property_id
- dimension: unread_messages_count
type: number
sql: ${TABLE}.unread_messages_count
- dimension_group: updated
type: time
timeframes: [time, date, week, month]
sql: ${TABLE}.updated_at
- dimension: username
type: string
sql: ${TABLE}.username
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- id
- username
- accounts.username
- accounts.service_account_id
- communications.count
- crawl_user_account_jobs.count
- messages.count
- reservations.count
- user_account_listing_details.count