Fusion Analytics Warehouse

Products Banner

Bell curve on performance Review

Question
141
Views
0
Comments

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

Tagged: