Supplied Benchmark Data
Supplied Survey Data
Engagment Data.xlsx|||`Sheet1$`
False
1
Engagment Data.xlsx
Table=`Sheet1$`
Department
Customer Operations
Customer Support
HR
Training
Q1:I understand how my role contributes to the company's mission.
4.1
5.8
5.3
5.1
Q2:My work is recognized by leadership.
4.8
4.6
5.4
4.4
Q3:I have access to the resources I need to achieve success.
6.1
5.7
5.2
4
Q4:I would recommend this workplace.
5.8
4.2
6.2
4.5
Q5:I feel informed of Senior Leadership's strategies and vision.
5.2
4.6
4.1
3.9
Capstone Exercise
Final State
Final State - Capstone.yxdb
Final State - Capstone.yxdb
Warn
Name - Ascending
Sample
2
1 of every 2
RecordID
1
Int32
6
0
Mod([RecordID], 2) = 0
Custom
=
RecordID
True
fixed
2019-11-13 15:53:40
0
2019-11-13 15:53:40
2019-11-13 15:53:40
Mod([RecordID], 2) = 0
RecordID
1
Int32
6
0
Warn
,
RightInputRows
Warn
Positional
Value
[Name] = "Field 1"
Simple
=
Name
True
fixed
2019-11-13 15:57:31
0
Field 1
2019-11-13 15:57:31
2019-11-13 15:57:31
[Name] = "Field 1"
Warning
All
ByName
RecordID
1
Int32
6
0
,
,
,
,
RightInputRows
Warn
Positional
Value
[Value] != "Name"
Simple
!=
Value
True
fixed
2019-11-13 19:55:06
0
2019-11-13 19:55:06
2019-11-13 19:55:06
Name
[Value] != "Name"
Warn
Warn
Delta = tonumber([Score]) - tonumber([Benchmark])
Review = iif([Delta] <= -1, "R...
Horizontal
Capstone