Make a Forecast based on holidays, and month usage hours

[josegracaaxians]

Hello,
Good Afternoon,

I have already a formula so I can get a forecast for the limit of the contracted hours, based on the used hours, and the average of the last 3 months:

But now I'd like to make a forecast based on employees' vacations and monthly consumption. For example: In January the client usually asks for a lot of work and there is a high consumption of hours, but in March there is usually no high consumption. And I'd like the forecast to also be based on these hours.

Thanks fofr the attention.

[Anonymous]

Hi @josegracaaxians ,

Your needs are not very clear and I'm not sure exactly how you would like them to be implemented.
But if I were to offer a little advice, I would suggest that you add two columns or two measures to your datasheet for calculating the hourly consumption factor and the number of workdays per month, respectively. For example, you could take February as the base month for each year, with a factor of 1 for February, a higher factor of 1.5 for January, and a lower factor of 0.75 for March, and then multiply your existing projections by the factor of hours worked, taking into account the number of workdays in the month.
If you have any other questions, please elaborate on how you specifically want to achieve your needs, as well as provide your sample data and desired results, thank you!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[josegracaaxians]

Hello, goood Morning,

And can you help me with that measures plz? And where could I implement them, in the [Cumulativo + Media] formula?

Thanks for the attention