Graph Actuals vs. Projections

[Drogov4122]

I created the attached graph based on actual monthly numbers and is being refreshed automatically. However, I do not want to see the drop in 2023 levels since the numbers are only for 14 days, hence the sharp drop compared to the other values. What would be the best method to perhaps insert an average begging in August or something similar to make a projection instead of the drop?

[Anonymous]

Maybe you could try using the linear regression function for this case and add the comment that's a calculus that's coming from previous months averages. 

[Syk]

Best way would be to do an average daily rate for the month. For example, for August it would show 2.3 since there are 14 days right now. July would show 2.6