You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Length of service - Groups

edited Oct 25, 2018 1:11AM in Reporting and Analytics for HCM 8 comments

Summary

How to group length of service

Content

Hi, I'm doing some reporting & dashboards and was looking for a way to group the years of service into groups.  i.e. number of staff in <2 years, 2-4 years etc.  Do I need to add a new calculated item or is there a function to group them when I add a graphic view?

Thanks 

Version

11g Release 1 (11.1.1)

Code Snippet

ET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Workforce Management - Worker Assignment Real Time"."Grade"."Grade Code" s_1,
   "Workforce Management - Worker Assignment Real Time"."Grade"."Grade Name" s_2,
   "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Gender" s_3,
   "Workforce Management - Worker Assignment Real Time"."Worker"."Employee Name" s_4,
   "Workforce Management - Worker Assignment Real Time"."Worker"."Person Number" s_5,
   DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Worker"."Employee Gender") s_6,
   "Workforce Management - Work Relationship Real Time"."Work Relationship"."# Of Years Service" s_7
FROM "Workforce Management - Worker Assignment Real Time"
WHERE
((DESCRIPTOR_IDOF("Workforce Management - Worker
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!