I have a Service Level Target for one of my team,. It has a monthly Target.
But I want to calculate the target dynamically based on the past performance.
For an example for the first 5 Days of operation if the team achieved less than the target, then we optimize the daily target in order to catch p the monthly target achievement.
I have attached the sample file, but the target is actually the monthly figure, I am looking forward to get a formula to calculate the dynamic daily targets.