Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!

How do you create a visual that updates with sales throughout the day


Level 1

when i worked somewhere previously, a colleague created this dashboard for a high demand product and we could see the sales and the adds update all day (maybe using the hour of day metric) and then we could see it as a visual and then either we could refresh or it would refresh by the hour. i cannot remember what metrics are needed to do this and then to create the visual after. any ideas welcome.


Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies


Community Advisor

I think there are a couple of different ways you could approach this.

You could build a workspace project for the current day and breakout by hours so you could see the key product sales volume throughout the day.

Depending upon the audience, this could also be a good use case for a mobile scorecard.

Here are example screenshots for each approach with demo data.  Also note that the data in Analytics has a delay, typically around an hour. 






Level 6

Just a a not on this, adobe runs about 45 mins behind real time in my experience. 


Community Advisor

In addition to the point about the 45 min delay to process data, you might want to use some custom date logic to only show up to the last hour of the day, and maybe compare the previous day up to the same hour.


You can set you "current" date range to:



And if you are comparing to yesterday, you can add a custom date comparison of:




This will at least hide all the empty rows, but that last hour of today may still be partial data due to the latency.




But at least I am not comparing the full yesterday to the partial today, and when not comparing you won't have all the empty rows that haven't happened yet.