Oracle Fusion Data Intelligence

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

Categories

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

seniority tenure range issue

Received Response
11
Views
2
Comments
Lauriane Massin Whitaker
Lauriane Massin Whitaker Rank 5 - Community Champion
in Oracle Fusion Data Intelligence

Hi,

Instead of using the FDI manually setup tenure bands that does not give me the result I'm looking for or the flixibility I need, I wanted to create a different metric for each range I wanted.

  • Seniority from 0 to 1,
  • From 1 to 2,
  • From 2 to 3.
image.png

I then created my first metric.

This issue I'm facing now is as follows: If I add the person number to my report, no issue, it works. But I do not want the person number… I just want the sum of the employees by legal entity. If I keep the person number indicator, my sum displys the number of lines in the report…..

image.png

And if I remove the person numbers, my 2 columns are then empty….

image.png

How can I do to create these 2 metrics without adding the person number indicator to my report ?

Really urgent… but really stuck :(

Thanks,

Lauriane

Answers

  • Sushanta Chakraborty-Oracle
    Sushanta Chakraborty-Oracle Rank 4 - Community Specialist

    Try putting a SUM within your case statement in the metric calculation.

    SUM(Case When "Years of Service (Person Seniority)" < 0.9999 Then 1 End)

  • Lauriane Massin Whitaker
    Lauriane Massin Whitaker Rank 5 - Community Champion

    I tried that as well, but either I end Up having the number of lines of the report displayed in that column or I have a blank column... Depends on when I have the person numbers added or not.

    Feel like I tried everything but it does not want to work BC it feels Line the years of work length will only work with the person number displayed.