-
Notifications
You must be signed in to change notification settings - Fork 0
/
Movements.dashboard.lookml
154 lines (141 loc) · 4.07 KB
/
Movements.dashboard.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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
- dashboard: movements
title: Movements
layout: tile
tile_size: 100
filters:
- name: date
title: "Event Date"
type: date_filter
default_value: last 12 months
elements:
- name: upward_mobility
title: Upward Mobility
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month]
measures: [measures_base.upward_mobility]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Upward Mobility']
hide_legend: true
- name: lateral_mobility
title: Lateral Mobility
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month]
measures: [measures_base.lateral_mobility]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Lateral Mobility']
hide_legend: true
- name: transfers
title: Transfers
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month, dim_event_reason.level2desc]
pivots: [dim_event_reason.level2desc]
measures: [measures_base.transfers]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Transfers']
hide_legend: true
- name: transfer_rate
title: Transfer Rate
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month]
measures: [measures_base.transfer_rate]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Transfer Rate']
hide_legend: true
- name: promotions
title: Promotions
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month, dim_event_reason.level2desc]
pivots: [dim_event_reason.level2desc]
measures: [measures_base.promotions]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Promotions']
hide_legend: true
- name: promotion_rate
title: Promotion Rate
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month]
measures: [measures_base.promotion_rate]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Promotion Rate']
hide_legend: true
- name: demotions
title: Demotions
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month, dim_event_reason.level2desc]
pivots: [dim_event_reason.level2desc]
measures: [measures_base.demotions]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Demotions']
hide_legend: true
- name: demotion_rate
title: Demotion Rate
type: looker_column
base_view: measures_base
dimensions: [measures_base.todate_month]
measures: [measures_base.demotion_rate]
listen:
date: measures_base.todate_date
sorts: [measures_base.todate_month asc]
limit: 500
stacking: normal
show_null_labels: false
show_null_points: false
x_axis_label_rotation: -45
y_axis_labels: ['Demotion Rate']
hide_legend: true