Forecast different periods

Anonymous · ‎05-17-2019

Hi!

I currently have calculted an AVERAGE of closed cases by employee in the last 30 days.

Now, I need to do some forecasts.

First, I would need to calculte, based on a slider indicating the amount of extra available employees, how many extra cases we will be able to close up untill next monday.

The second slider then starts from that monday and also indicates extra employees. I need to forecast the amount of extra cases closed from that monday up untill the week after. This forecast has to take in account the first forecast.

How to solve this?

v-piga-msft · ‎05-19-2019

Hi @Anonymous ,

More details will be helpful.

If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that we could understand your scenario better and help further on it.

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.