cancel
Showing results for 
Search instead for 
Did you mean: 

Help in getting Vacant Positions using the Incumbent First Name & Last Name columns

LissieDomingo03
Explorer
0 Kudos
122

I am trying to get all vacant positions for Succession Planning and ideally, a table for export of all vacant positions and positions with incumbent as of date in one table.

  • I thought that filtering for Incumbent name = Null would get me all vacant positions.
  • Issue: When I filtered for Incumbent name = Null, this only included positions where there was never an incumbent ever. This excluded positions whose previous incumbents had left the company already (Employee Status = Terminated).

First, I set my Time Filter for Incumbents to Today (same as the first table). I was thinking, this should only give Active incumbents AND incumbent field that is blank (terminated incumbents OR no one was ever in that position). But, I am getting even terminated ones and multiple rows for some positions even.

LissieDomingo03_2-1718285795648.png

LissieDomingo03_0-1718285233090.png

Next, I created a calculated field in the query to calculate if an Incumbent field (Concatenated field of incumbent first and last name) is blank or with a terminated employee status = 0.

LissieDomingo03_1-1718285522044.png

This is what I got. But in my table, I only want to show those in green highlight (no incumbents and active incumbents).

LissieDomingo03_3-1718285866861.png

Note: I have created a canvas advanced reporting with the same date filters of incumbents as of today and I got all active incumbents and blank incumbents into one report.

LissieDomingo03_4-1718286111575.png

Is there a way to achieve this (same as advanced reporting) in Story?

SAP SuccessFactors People Analytics 

View Entire Topic
JeroenA
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Lissie,

You are on the right track. The incumbents table contains also incumbents that are terminated. Even with date filter set to "Today". With Position make sure you set a filter on record status = "N" and status = "Active"

JeroenA_0-1718346635173.png

You can also create a calculated column for Vacant / Non-Vacant:

IF(ISNULL([Employment#Incumbents#User ID] ) ,"Yes" ,"No" )

Kind regards,

Jeroen