Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

FDI Category not displaying by group - HCM Workforce Absence Managment

Received Response
16
Views
1
Comments
Scott_Turner_
Scott_Turner_ Rank 5 - Community Champion
in Oracle Fusion HCM Analytics

I have written a calculation to place the Accrual Balance into bins based on the number of weeks Annual Leave. The calculation has placed the leave into the correct bins as it is displaying each in the table (see below) however when I add the calculation to a visual it only displays the last item in the bin (>12 weeks). Any suggestions on how to resolve this issue?

20240501 Leave Categories.png 20240501 Leave Category Table.png 20240501 Leave Category Visual.png
Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics Coach

    Hi Scott,

    I don't see the Headcount in your tabular workbook so it is a little hard to compare the two.

    I create a Visualization similar to yours with a Case statement.

    image.png

    This matches what I see in the Tabular Workbook if I include the 2 columns.