Need to find the count of vacant positions

KeerthanaBaskaran

To get the vacant positions, I'm using column the 'Number of Positions without incumbents' from the Subject area 'HCM - Positions'. But we have special case, if the position is occupied by Pending worker then those position also considered as vacant position.

I have tried multiple calculations using Subject area 'HCM - Workforce Core' but nothing works.

Kindly share ideas if anybody faced this in FAW.

Thanks,

Keerthana.

Mallikarjuna Kuppauru-Oracle

Hi @KeerthanaBaskaran

As per our Data Lineage documentation -

https://docs.oracle.com/en/cloud/saas/analytics/24r1/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

Number of Positions without Incumbents —> Count(Distinct Position ID) Where Active Status = 'Active' AND Incumbent Count = 0

If you think this calculation is not satisfied with your business need , please create custom metric.

Regards,

Arjun