-
Notifications
You must be signed in to change notification settings - Fork 0
/
candidates.view.lookml
82 lines (61 loc) · 1.5 KB
/
candidates.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
- view: candidates
sql_table_name: one.candidates
fields:
- dimension: candidateid
primary_key: true
sql: ${TABLE}.candidateid
- dimension_group: dob
type: time
timeframes: [date, week, month]
convert_tz: false
sql: ${TABLE}.dob
- dimension: educationlevel
sql: ${TABLE}.educationlevel
- dimension_group: effdt
type: time
timeframes: [date, week, month]
convert_tz: false
sql: ${TABLE}.effdt
- dimension_group: enddt
type: time
timeframes: [date, week, month]
convert_tz: false
sql: ${TABLE}.enddt
- dimension: ethnicgroup
sql: ${TABLE}.ethnicgroup
- dimension: firstname
sql: ${TABLE}.firstname
- dimension: fullname
sql: ${TABLE}.fullname
- dimension: gender
sql: ${TABLE}.gender
- dimension: homecity
sql: ${TABLE}.homecity
- dimension: homecountry
sql: ${TABLE}.homecountry
- dimension: homestate
sql: ${TABLE}.homestate
- dimension: homezip
sql: ${TABLE}.homezip
- dimension: lastname
sql: ${TABLE}.lastname
- dimension: nationality
sql: ${TABLE}.nationality
- dimension: personid
sql: ${TABLE}.personid
- dimension: rcm_cand_id
type: int
sql: ${TABLE}.rcm_cand_id
- measure: count
type: count
drill_fields: detail*
# ----- Sets of fields for drilling ------
sets:
detail:
- candidateid
- fullname
- firstname
- lastname
- applications.count
- view_rcm_applications_denormal.count
- view_rcm_candidates_denormal.count