Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Length of service - Groups
Summary
How to group length of serviceContent
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
0