seniority tenure range issue

Question

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.

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…..

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

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

Lauriane Massin Whitaker · Answer

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.

Sushanta Chakraborty-Oracle · Answer

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)