Need to find the count of vacant positions

Question

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 · Accepted Answer

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