Forum Discussion

Drogov4122's avatar
Drogov4122
Regular Visitor
3 years ago

Graph Actuals vs. Projections

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?

 

2 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.