Hi all,
I am creating a sales dashboard for my office with excel and Data Studio. What I would like to do is show the amount of sales required per day for the remaining days of the month which I have managed to do. The bit I'm struggling with is that my colleagues don't want it to update throughout the day.
For example, if when we start the day we need to hit £1000 of sales to keep up on track, we would like it to stay at that figure until the end of the day rather than gradually decreasing as we get sales during the day. We only want it to update that figure the following morning (at which point it will have either gone up or down depending on if we hit the target or not)
The problem is that if it updates during the day, the new figure is just the amount we need per day spread over the month rather than the amount we need today to keep us on track.
I think what we need is something either in the source in excel that only calculates the values at a set time (say 8:00am) each day.
Unless there's a better way to do this? I can see a few people have discussed sales dashboards here so maybe a solution already exists.
Many thanks in advance!
Richard
Bookmarks