We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Bell curve on performance Review
Summary:
Hi
I am trying to create a bell curve from the performance review for a period document and for a particular department.
Since we do not have data for all the rating values, I am using the union to have the initial values for some of the ratings.
Here the challenge is data value starts from the 3rd rating model, so the bell curve begins from the middle.
Is there any way I can use the default values?, so that the bell curve starts from first rating value itself.
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
CASE "Workforce Performance - Performance Rating Real Time"."- Rating Level"."Numeric Rating" WHEN NULL THEN 0 ELSE "Workforce Performance - Performance Rating Real Time"."- Rating Level"."Numeric Rating" END saw_0,
CASE "Workforce Performance - Performance Rating Real Time"."- Rating Level"."Rating Description" WHEN NULL THEN 'Not Rated' ELSE "Workforce Performance - Performance Rating Real Time"."- Rating Level"."Rating Description" END saw_1,
"Workforce Performance - Performance Rating Real Time"."Organization"."Organization Name" saw_2,
"Workforce Performance - Performance Rating Real Time"."Performance Document Participant"."Role Definition" saw_3,
"Workforce Performance - Performance Rating Real Time"."Performance Document"."Performance Document Period Name" saw_4,
"Workforce Performance - Performance Rating Real Time"."Worker"."Person Number" saw_5,
Count("Workforce Performance - Performance Rating Real Time"."Worker"."Person Number") saw_6
FROM "Workforce Performance - Performance Rating Real Time"
WHERE
("Workforce Performance - Performance Rating Real Time"."Performance Document"."Performance Document Period Name" = '@PDName') AND ("Workforce Performance - Performance Rating Real Time"."Organization"."Organization Name" IN (@Org_Name)
UNION ALL select 0 "saw_0", 'Not Rated' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5" ,NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY UNION ALL select 1 "saw_0", 'Non Contributor' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5" , NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY UNION ALL select 2 "saw_0", 'Basic Contributor' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5" , NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY UNION ALL select 3 "saw_0", 'Successful Contributor' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5" ,NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY UNION ALL select 4 "saw_0", 'High Contributor' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5" ,NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY UNION ALL select 5 "saw_0", 'Exceptional Contributor' "saw_1" , NULL "saw_2", NULL "saw_3", NULL "saw_4", NULL "saw_5", NULL "saw_6" from "Workforce Performance - Performance Rating Real Time" FETCH FIRST 1 ROWS ONLY ORDER BY saw_0, saw_1, saw_2, saw_3, saw_4, saw_5