2013 Client LMP Dashboard
HiWelcome to the Training Dashboard. | ||
Please select which training program you would like to view.
WordPress database error: [Unknown column 's.employee_id' in 'field list']
SELECT
SUM(if(positive_ct>0,1,0)) as positive_ct,
SUM(if(negative_ct>0,1,0)) as negative_ct,
SUM(if(no_change_ct>0,1,0)) as no_change_ct,
SUM(if(pd_average=5,1,0)) as pd_five_ct,
SUM(if(pd_average=4,1,0)) as pd_four_ct,
SUM(if(pd_average=3,1,0)) as pd_three_ct,
SUM(if(pd_average=2,1,0)) as pd_two_ct,
SUM(if(pd_average=1,1,0)) as pd_one_ct,
SUM(if(e_average=5,1,0)) as e_five_ct,
SUM(if(e_average=4,1,0)) as e_four_ct,
SUM(if(e_average=3,1,0)) as e_three_ct,
SUM(if(e_average=2,1,0)) as e_two_ct,
SUM(if(e_average=1,1,0)) as e_one_ct
FROM (
SELECT
s.employee_id,
sum(if(q.answer_after>q.answer_before,1,0)) as positive_ct,
sum(if(q.answer_after<q.answer_before,1,0)) as negative_ct,
sum(if(q.answer_after=q.answer_before,1,0)) as no_change_ct,
round(avg(if(q.question_type='PD',q.answer_after,NULL))) as pd_average,
round(avg(if(q.question_type='E',q.answer_after,NULL))) as e_average
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.answer in ('1','2','3','4','5')
GROUP BY s.employee_id
) as emps
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
REPLACE(s.employee_name,'''','') as employee_name,
ROUND(avg(q.answer_before)) as before_ct,
IFNULL(ROUND(avg(q.answer_after)),0) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type = 'PD'
GROUP BY s.employee_name
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
REPLACE(s.employee_name,'''','') as employee_name,
(ROUND(avg(q.answer_before))-
IFNULL(ROUND(avg(q.answer_after)),0)) as diff_ratio
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type = 'PD'
GROUP BY s.employee_name
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
REPLACE(s.employee_name,'''','') as employee_name,
ROUND(avg(q.answer_before)) as before_ct,
IFNULL(ROUND(avg(q.answer_after)),0) as after_ct
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type = 'E'
GROUP BY s.employee_name
WordPress database error: [Unknown column 's.employee_name' in 'field list']
SELECT
REPLACE(s.employee_name,'''','') as employee_name,
(ROUND(avg(q.answer_before))-
IFNULL(ROUND(avg(q.answer_after)),0)) as diff_ratio
FROM ey3_surveys s JOIN ey3_survey_questions q ON q.survey_id = s.id
WHERE q.question_type = 'E'
GROUP BY s.employee_name