Skip to main content

Hello to all Pigment enthusiasts,

To estimate my number of Headcounts over the coming months (Forecast), I'm taking the Headcounts on an HR board (here with Position ID with Contract) that you see on the lines in this metric.
(Dimensions: Position ID, Month, Period Type)
 

I'd like to be able to push the values over the following months. Concretely, even if the person (PO 312) is recruited in March 2024, he must be present in all the following months and therefore should have 1 in April 2024, May 2024…

Many thanks for your help

Hi!

There are two options you can explore - using either PREVIOUS or PRORATA. 

PREVIOUS is a function that can be used to “push” the data. In your example, you could use it in combination with IFBLANK and type a formula like this 

IFBLANK(JobOpening.FTEnFILTER: XX]RBY COUNT: YY], PREVIOUS(Month))

This means if you have a value, take the value, if not take the previous month’s value.

 

I prefer working with PRORATA though, especially on larger datasets as it tends to compute faster (which becomes handy if you have millions of rows, or a very large calendar).

So instead of JobOpening.FTEeFILTER: XX]LBY COUNT: JobOpening.'Position ID', JobOpening.'Arrival Date (Dimension)'], you can type

PRORATA(JobOpening.FTEeFILTER: XX], JobOpening.'Arrival Date')aBY COUNT: JobOpening.'Position ID']

By providing only a start date for the prorata, it will be continued until the calendar ends. Be mindful you have to provide a date and not a dimension like in the BY.

 

Hope this helps!

Hello François,

Many thanks for this, it works perfectly!!!!

Have a great day,

Reply


Ask your question here!

Terms & ConditionsCookie settings