-
Notifications
You must be signed in to change notification settings - Fork 0
/
Anniversaries.dashboard.lookml
133 lines (118 loc) · 3.96 KB
/
Anniversaries.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
- dashboard: employee_event_anniversaries
title: Anniversaries
layout: tile
tile_size: 100
filters:
- name: date
title: "Event Date"
type: date_filter
default_value: this week
- name: department_lvl_2
title: "Department Level 2"
type: suggest_filter
base_view: dim_org_unit
dimension: dim_org_unit.level2desc
- name: country
title: "Country"
type: suggest_filter
base_view: dim_country
dimension: dim_country.level1desc
elements:
- name: birthdays_year
title: Birthdays and Hire Anniversaries by Month
type: looker_column
base_view: measures_employee_daily
dimensions: [measures_employee_daily.todate_month]
measures: [measures_employee_daily.birthdays_total, measures_employee_daily.hire_anniversaries]
filters:
measures_employee_daily.todate_date: this year
listen:
department_lvl_2: dim_org_unit.level2desc
country: dim_country.level1desc
sorts: [measures_employee_daily.todate_month]
limit: 500
show_null_labels: false
colors: [lightgreen,olive]
stacking: ''
x_axis_label_rotation: -45
y_axis_labels: ['Birthdays and Hire Anniversaries This Year']
y_axis_combined: true
hide_legend: true
width: 10
height: 4
- name: birthdays_week
title: Birthdays in Selected Period
type: looker_column
base_view: measures_employee_daily
dimensions: [measures_employee_daily.todate_date]
measures: [measures_employee_daily.birthdays_total]
filters:
measures_employee_daily.todate_date: this week
listen:
department_lvl_2: dim_org_unit.level2desc
country: dim_country.level1desc
date: measures_employee_daily.todate_date
sorts: [measures_employee_daily.todate_date]
limit: 500
show_null_labels: false
colors: [lightgreen]
stacking: ''
x_axis_label_rotation: -45
y_axis_labels: ['Birthdays in Selected Period']
hide_legend: true
width: 5
height: 4
- name: birthday_period_table
title: People with Birthdays in Selected Period
type: table
base_view: measures_employee_daily
dimensions: [measures_employee_daily.todate_date, measures_employee_daily.firstname,
measures_employee_daily.lastname]
filters:
measures_employee_daily.todate_date: this week
measures_employee_daily.birthday_count: '1'
listen:
department_lvl_2: dim_org_unit.level2desc
country: dim_country.level1desc
date: measures_employee_daily.todate_date
sorts: [measures_employee_daily.todate_date desc]
limit: 500
width: 5
- name: hire_anniversary_week
title: Hire Anniversaries in Selected Period
type: looker_column
base_view: measures_employee_daily
dimensions: [measures_employee_daily.todate_date]
measures: [measures_employee_daily.hire_anniversaries]
filters:
measures_employee_daily.todate_date: this week
listen:
department_lvl_2: dim_org_unit.level2desc
country: dim_country.level1desc
date: measures_employee_daily.todate_date
sorts: [measures_employee_daily.todate_date desc]
limit: 500
show_null_labels: false
colors: [olive]
stacking: ''
x_axis_label_rotation: -45
y_axis_labels: ['Hire Anniversaries in Selected Period']
width: 5
height: 4
- name: hire_anniversary_period_table
title: People with Hire Anniversaries in Selected Period
type: table
base_view: measures_employee_daily
dimensions: [measures_employee_daily.todate_date, measures_employee_daily.firstname,
measures_employee_daily.lastname]
measures: [measures_employee_daily.average_tenure_daily]
filters:
measures_employee_daily.todate_date: this week
measures_employee_daily.hire_anniversaries: '1'
listen:
department_lvl_2: dim_org_unit.level2desc
country: dim_country.level1desc
date: measures_employee_daily.todate_date
sorts: [measures_employee_daily.todate_date desc]
limit: 500
width: 5