Position date Vacancy in storie report

[Jhonatan]

Comunidad SAP, saben como puedo capturar el campo de cálculo cuando un puesto está en estado vacante, les comparto una imagen donde vemos que se calcula el tiempo que el puesto está vacante, quiero tener este campo para informe de storie. ¿Tienes alguna recomendación sobre cómo traerme la fecha en caso de que el puesto esté vacante?

[T_Eva]

Hello Jhonatan,

One alternative for you is to create and use a calculated column in your report for Position Object, and then calculate the difference in days between the start date of the Position and the current date, for example:

DAYS_BETWEEN([Position#Position#Start Date] ,CURRENTDATE() )

Please check "Using Stories in People Analytics" in case you need more information about how to create a calculated column.

Regards.

Thiago Eva

[Jhonatan]

Hi Thiago Eva, I hope you are very well. Thank you very much for your contribution, validating, it does not bring me the date in which the Vacant field has the value of yes, example, if the position 12345 is created on 04/06/2024 and has the vacant field yes, if you add another event with a change and this is the last one when applying the formula it will bring me the last date. Is it possible to bring the date since the vacant field is equal to si? as we see in the image?