Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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